Обсуждение: Conversion of \n to \r\n

Поиск
Список
Период
Сортировка

Conversion of \n to \r\n

От
"Saltsgaver, Scott"
Дата:
I am currently using PostgreSQL 7.02 and unixODBC driver 1.8.7 driver on an
HP-UX 11.00 system.  I have a question on the storing and retrieving of text
fields with new lines encoded as \n.  

When I store the following string 

Hello\nWorld

and then perform a query against the row, I get back

Hello\r\nWorld

I was expecting to get

Hello\nWorld

Is there an attribute in the connection that must be set for this to work?
Or does the driver require recompilation?  Or is it that this is just how
standard SQL works?

Thanks for your help,

Scott Saltsgaver
scottsa@aiinet.com

Re: Conversion of \n to \r\n

От
Tom Lane
Дата:
"Saltsgaver, Scott" <scottsa@aiinet.com> writes:
> I am currently using PostgreSQL 7.02 and unixODBC driver 1.8.7 driver on an
> HP-UX 11.00 system.  I have a question on the storing and retrieving of text
> fields with new lines encoded as \n.  

> When I store the following string 

> Hello\nWorld

> and then perform a query against the row, I get back

> Hello\r\nWorld

You sure you haven't got any MicroSloth software in your food chain?
I get \n back, just as expected, using HPUX 10.20.  (I don't use ODBC
though, so maybe unixODBC is to blame.)
        regards, tom lane