| From: | "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Barry Bell <Barry_Bell(at)harte-hanks(dot)com> |
| Cc: | "Frank A(dot) U(dot)" <fau(at)email(dot)com>, psql-odbc <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: B7 option |
| Date: | 2013-08-02 00:04:48 |
| Message-ID: | 51FAF7A0.9070503@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 for each 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Bell | 2013-08-05 14:39:16 | ODBC asci characters 128-159 with ANSI driver |
| Previous Message | Barry Bell | 2013-08-01 12:40:18 | FW: B7 option |