Can I change the character encoding for a DB?

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Can I change the character encoding for a DB?
Date: 2004-01-26 08:28:49
Message-ID: 000901c3e3e6$6cd00060$7201a8c0@mst1x5r347kymb
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

I created a DB with SQL_ASCII encoding but I want to change it to EUC_JP.
Can I do this without creating a new database? I didn't find a way in the
docs, sorry.

set server_encoding = EUC_JP;

didn't work.

My understanding is that the encoding is purely information and doesn't
actually affect the data stored in the DB. Is that right?

The reason I want to do this is that my java app is corrupting Japanese
Kanji. I suspect that the JDBC driver uses this information. VB apps using
ODBS seem to be fine.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gary Stainburn 2004-01-26 10:50:48 Re: [SQL] Database diagram
Previous Message Mauri Sahlberg 2004-01-26 07:02:42 Re: Procedures, triggers and transactions...