pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Conversion of \n to \r\n 2+ messages / 2 participants [nested] [flat]
* Conversion of \n to \r\n @ 2000-08-23 18:23 Saltsgaver, Scott <scottsa@aiinet.com> 0 siblings, 1 reply; 2+ messages in thread From: Saltsgaver, Scott @ 2000-08-23 18:23 UTC (permalink / raw) To: 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@aiinet.com ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Conversion of \n to \r\n @ 2000-08-24 03:47 Tom Lane <tgl@sss.pgh.pa.us> parent: Saltsgaver, Scott <scottsa@aiinet.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2000-08-24 03:47 UTC (permalink / raw) To: Saltsgaver, Scott <scottsa@aiinet.com>; +Cc: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-08-24 03:47 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-08-23 18:23 Conversion of \n to \r\n Saltsgaver, Scott <scottsa@aiinet.com> 2000-08-24 03:47 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox