Search Postgresql Archives

Postgres automatically inserts chr(13) whenever chr(10) is inserted

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



create table sample(column_sample varchar(500))

insert into sample(column_sample) values('this is first row of text' || chr(10) || 'this is second row of text')

Now, instead of just inserting chr(10), postgres inserts chr(13) + chr(10). Is there a way to avoid this? Database is on a linux server with SQL_ASCII encoding, clients are winXP communicating thru ODBC.

Tnx in advance

DRagan Matic




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux