Re: Conversion of \n to \r\n

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Saltsgaver, Scott" <scottsa(at)aiinet(dot)com>
Cc: "Pgsql-Interfaces (E-mail)" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Conversion of \n to \r\n
Date: 2000-08-24 03:47:22
Message-ID: 20923.967088842@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

"Saltsgaver, Scott" <scottsa(at)aiinet(dot)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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Rasca Gmelch 2000-08-24 10:04:46 Re: open for other OSes!?
Previous Message Thomas Lockhart 2000-08-24 03:20:34 Re: open for other OSes!?