Re: Postgres - Unicode - Problem
Hi Andreas!
On Wed, Jun 11, 2003 at 03:23:35PM +0200, Andreas Tille wrote:
> psql template1 <<...
> CREATE DATABASE $dbtocreate ENCODING 'unicode';
This is the encoding used internally by PostgreSQL.
> psql $dbtocreate <<...
...
> INSERT INTO i18n_translations(lang, orig, trans) values
> ('de_DE', 'public', 'öffentlich');
You also have to make sure psql uses the same encoding you're using in
your shell or terminal. (Run `locale | grep LC_CTYPE`)
Use "\encoding latin1", "\encoding unicode" or something appropriate. If
they don't match with LC_CTYPE, the postgres backend translates umlauts
to garbage and complains loudly.
BYtE
Philipp
--
Philipp Matthias Hahn <pmhahn@debian.org>
GPG/PGP: 9A540E39 @ keyrings.debian.org
Reply to: