Conversion of \n to \r\n

From: "Saltsgaver, Scott" <scottsa(at)aiinet(dot)com>
To: "Pgsql-Interfaces (E-mail)" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Conversion of \n to \r\n
Date: 2000-08-23 18:23:35
Message-ID: 7283DE19D141D111AD0E00A0C95B195503A59D68@mail2.aiinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)aiinet(dot)com

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message amish seth 2000-08-23 21:04:04 Solaris Platform support!
Previous Message Rasca Gmelch 2000-08-23 17:33:05 open for other OSes!?