Re: ODBC 09.03.0100 - Issue with new-line-conversion

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Andreas <maps(dot)on(at)gmx(dot)net>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Cc: hiroshi(at)winpg(dot)jp
Subject: Re: ODBC 09.03.0100 - Issue with new-line-conversion
Date: 2014-02-20 16:32:51
Message-ID: 53062E33.9010302@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 02/20/2014 08:26 AM, Andreas wrote:
> Hi Hiroshi,
>
> is there an issue with new-line-conversion in the new ODBC 09.03.0100 ?
>
> I've got an PG 9.3 64bit server on Linux.
> The clients are Win XP or 7 with MS-Access 2003 or 2010.
> All ODBC are 32 bit.
>
> I've got the new-line-conversion as parameter in the connection string
> as PG uses only LF and Access needs CRLF.
> Up until V09.02.0100 the on the fly conversion works.
>
> With 09.03.0100 the line breaks in text fields get lost when displayd in
> Access.
>
> Is there a changed parameter or is there a bug in the new ODBC?

Yes.

See this thread:

http://www.postgresql.org/message-id/006a01cf28e4$7c425450$74c6fcf0$@de

In particular:

http://www.postgresql.org/message-id/5303F655.8000200@tpf.co.jp

and

http://www.postgresql.org/message-id/530551A5.7010104@tpf.co.jp
>
>
> Regards
> Andreas
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Andreas 2014-02-20 17:06:44 Re: ODBC 09.03.0100 - Issue with new-line-conversion
Previous Message Andreas 2014-02-20 16:26:12 ODBC 09.03.0100 - Issue with new-line-conversion