Re: B7 option - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: B7 option
Date
Msg-id 51FAF7A0.9070503@tpf.co.jp
Whole thread Raw
In response to Re: B7 option  (Barry Bell <Barry_Bell@harte-hanks.com>)
List pgsql-odbc
(2013/08/01 21:36), Barry Bell wrote:
> If there a is a LF(char(10) inside a string and the B7=1, the string returned by the driver will cut off 1 character
foreach LF(chr(10) inside the string. 
> If the B7=0 the full string si returned.
>
> Field='ABC (LF)123'
>
> Ex:  B7=1
> Field='ABC (LF)12'
> EX B7=0:
> Field='ABC (LF)123'
>
> Any idea why a chr(10) (LF) in a field would cause this?

Seems there are some bugs in LF<->CRLF conversions.
I would examine it.

Anyway please specify *LFconversion=0* or *C5=0* in your
connection string to suppress LF<->CRLF conversion.

regards,
Hiroshi Inoue




pgsql-odbc by date:

Previous
From: Barry Bell
Date:
Subject: FW: B7 option
Next
From: Barry Bell
Date:
Subject: ODBC asci characters 128-159 with ANSI driver