Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e7O3lp582088 for ; Wed, 23 Aug 2000 23:47:51 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id XAA20926; Wed, 23 Aug 2000 23:47:23 -0400 (EDT) To: "Saltsgaver, Scott" cc: "Pgsql-Interfaces (E-mail)" Subject: Re: Conversion of \n to \r\n In-reply-to: <7283DE19D141D111AD0E00A0C95B195503A59D68@mail2.aiinet.com> References: <7283DE19D141D111AD0E00A0C95B195503A59D68@mail2.aiinet.com> Comments: In-reply-to "Saltsgaver, Scott" message dated "Wed, 23 Aug 2000 14:23:35 -0400" Date: Wed, 23 Aug 2000 23:47:22 -0400 Message-ID: <20923.967088842@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200008/133 "Saltsgaver, Scott" 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