[GENERAL] Postgres automatically inserts chr(13) whenever chr(10) is inserted

[Dragan Matic]

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



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match