"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