Thread: [ psqlodbc-Bugs-1010516 ] Carriage return added to Line Feed on conversion from SQL_LONGVARCHAR to text
Bugs item #1010516, was opened at 2008-11-29 17: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: Nobody (None) 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 '¶' ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010516&group_id=1000125