cant support non ascii character... - Mailing list pgsql-general

From Twist
Subject cant support non ascii character...
Date
Msg-id 9dnine$sh1$1@news.tht.net
Whole thread Raw
Responses Re: cant support non ascii character...  (Tony Grant <tony@animaproductions.com>)
List pgsql-general
Hi, im trying to get postgres and cygwin work with non ascii characters.

i enabled multibyte, i set LATIN1 while doing the initdb.

psql -l tells me that all database r using LATIN1.

how ever when i try the following:

psql test
create table test(name text);
insert into test values('pr�f�r�');

then select * from test, i got :
pr<E9>f<E9>r<E9>

tried under linux, it works fine, so i assume it comes from cygwin somehow.

Any idea please ?
Thx in advance



pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: Re: What's the best front end/client under MS Windows?
Next
From: "hiroko"
Date:
Subject: Roooooooooooooll back!