Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group