Re: Conversion of \n to \r\n - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Conversion of \n to \r\n
Date
Msg-id 20923.967088842@sss.pgh.pa.us
Whole thread Raw
In response to Conversion of \n to \r\n  ("Saltsgaver, Scott" <scottsa@aiinet.com>)
List pgsql-interfaces
"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


pgsql-interfaces by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: open for other OSes!?
Next
From: "Peter Mount"
Date:
Subject: Re: using large objects with jdbc/odbc