Re: Inserting Non English characters in a varchar type field

From: "Oliver Friedrich" <oliver(at)familie-friedrich(dot)de>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Inserting Non English characters in a varchar type field
Date: 2002-01-25 14:18:49
Message-ID: BCEFLCEOHFPNLLAKKGAAOEKFCIAA.oliver@familie-friedrich.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

I think, you must adjust the Characterset of your database. By default it is
ASCII, but you can create databases with unicode or one of the europien
character sets (LATIN-1 or something else)

That should solve your problem.

Oliver Friedrich

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Sulakshana
Awsarikar
Sent: Friday, January 25, 2002 2:26 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Inserting Non English characters in a varchar type field

Hi

I am trying to insert non english characters ( chars which lie in the
128-255 range in the ASCII character set ). When I try to get this data from
the table, I am getting garbled data. Is there any way to insert and
retrieve non english characters in pgsql

regards
Sulakshana

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB SD 2002-01-25 14:21:22 Re: Savepoints
Previous Message Oleg Bartunov 2002-01-25 14:08:38 new module contrib/tree for 7.2 ?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Eric Webber 2002-01-25 21:40:27 trying to compile postgres with java support
Previous Message Sulakshana Awsarikar 2002-01-25 13:25:37 Inserting Non English characters in a varchar type field