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

From: Dragan Matic <mlists(at)panforma(dot)co(dot)yu>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres automatically inserts chr(13) whenever chr(10) is inserted
Date: 2006-03-03 07:47:00
Message-ID: 4407F474.7030506@panforma.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-03-03 09:14:40 Re: Postgres automatically inserts chr(13) whenever chr(10) is inserted
Previous Message Chris 2006-03-03 07:00:55 Re: extended index info