[ 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 feed character 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