Postgres automatically inserts chr(13) whenever chr(10) is inserted - Mailing list pgsql-general

From Dragan Matic
Subject Postgres automatically inserts chr(13) whenever chr(10) is inserted
Date
Msg-id 4407F474.7030506@panforma.co.yu
Whole thread Raw
Responses Re: Postgres automatically inserts chr(13) whenever chr(10) is inserted  (Michael Fuhr <mike@fuhr.org>)
Re: Postgres automatically inserts chr(13) whenever chr(10) is inserted  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: extended index info
Next
From: Michael Fuhr
Date:
Subject: Re: Postgres automatically inserts chr(13) whenever chr(10) is inserted