Summary
Activity
Tracker
SCM
Files

[#1010516] Carriage return added to Line Feed on conversion from SQL_LONGVARCHAR to text

View Trackers | Bugs | Download .csv | Monitor

Date:
2008-11-29 22:15		 Priority:
3
State:
Open
Submitted by:
Farid Zidan (faridz) 		Assigned to:
Hiroshi Inoue (hinoue)
Category:
Interface (example)		 Group:
Resolution:
None		 Category:
Interface (example)
Group:
Resolution:
None
Summary:
Carriage return added to Line Feed on conversion from SQL_LONGVARCHAR to text

Detailed description
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 '¶'

Followup

Message
Date: 2008-12-04 02:42
Sender: Farid Zidan

I did not know I needed to do that. When I store a string in
a text column in the database, I assume the database is
going to store it exactly as I send it to the database and
preserve all the characters of the string. If there an
option to convert LF -> CR/LF this option must not be
enabled by default. I save "hello<LF>world" to the database,
I expect I will have "hello<LF>world" stored in the database
and not something else.

This works in all the databases I use: Firebird, MS SQL
Server, Oracle, DB2, Sybase. They all do not do any behind
the scene conversions of LF -> CR/LF for text columns and I
would so expect PostgreSQL by default. The option of
converting LF -> CR/LF may be helpful for some situations
but should not be the default behavior.

I would change this bug report to have this option disabled
by default so that that the database stores text exactly as
the user send them.

Regards,
Farid
Date: 2008-12-03 23:55
Sender: Hiroshi Inoue

Did you try to turn off LF <-> CR/LF convesion option ?

Attached Files:

Changes:

Field Old Value Date By
assigned_tonone2008-12-03 23:55hinoue
Powered By FusionForge