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.
***********************************************************************