Bugs item #1010516, was opened at 2008-11-29 22:15
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010516&group_id=1000125
Category: Interface (example)
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
>Assigned to: Hiroshi Inoue (hinoue)
Summary: Carriage return added to Line Feed on conversion from SQL_LONGVARCHAR to text
Initial Comment:
ODBC driver PostgreSQL ANSI 8.03.04.00
Windows XP SP3
Database Encoding WIN1252
Server PostgreSQL 8.3.5
Using bind parameters, column is bound as SQL_LONGVARCHAR. Driver is adding a carriage return character to each line
feedcharacter it finds in the insert statement parameters.
create table test_query (
rs_oid INT4 not null,
query_text TEXT not null,
constraint PK_TEST_QUERY primary key (rs_oid)
Source string:
select¶* ¶from¶test
Inserted string:
select§¶* §¶from§¶drg
where
Carriage Return is '§'
Line Feed '¶'
----------------------------------------------------------------------
>Comment By: Hiroshi Inoue (hinoue)
Date: 2008-12-03 23:55
Message:
Did you try to turn off LF <-> CR/LF convesion option ?
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010516&group_id=1000125