Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group