Re: \n converted to \r\n - Mailing list pgsql-odbc

From Trewern, Ben
Subject Re: \n converted to \r\n
Date
Msg-id 996802F75C3CD411B424001083FA445BB239A4@CET_PONXX_FP001
Whole thread Raw
In response to \n converted to \r\n  (Amir Zicherman <amir.zicherman@gmail.com>)
List pgsql-odbc

There's a setting on page 2 of the Advanced options of the Windows driver applet which says:

LF <-> CR/LF conversion

Seems like a good place to start ;)

Ben

> -----Original Message-----
> From: Jeff Eckermann [mailto:jeff_eckermann@yahoo.com]
> Sent: 01 October 2004 14:57
> To: Amir Zicherman; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] \n converted to \r\n
>
>
> --- Amir Zicherman <amir.zicherman@gmail.com> wrote:
>
> > Hello,
> >
> > I'm currently running version 07_03_0200 of the
> > Insight Distribution
> > Systems PostgreSQL Driver for windows.  when I
> > retrieve col1 string
> > from the database using:  "SELECT * FROM MyTable
> > WHERE col1='hello\n'"
> >  the value returned for col1 through the driver is
> "hello\r\n", and I
> > want it to be as it is stored in the database
> > ('hello\n" with no \r).
> > Is this a configuration issue?  If so, where can I
> > change the
> > configuration to ensure that this conversion won't
> > happen?
>
> I don't believe that there is any user-settable option
> to disable that functionality.  The driver assumes
> that the returned value will (or may) be required for
> display, so on Windows, \r\n is the appropriate
> combination.  No doubt this makes sense 99.9% of the
> time.
>
> Perhaps if you could tell us what it is that you are
> trying to do, someone on the list can suggest a
> workaround that will do the job for you.
>

***********************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
***********************************************************************

pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: \n converted to \r\n
Next
From: "Dave Page"
Date:
Subject: Re: \n converted to \r\n