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

Re: Unicode encoding

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "William Sweet" <wsweet(at)register(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: Unicode encoding
Date: 2004-04-27 16:44:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
William Sweet wrote:
> support is enabled. Now, I'd like to only store Unicode chars in my
> PostgreSQL dbs. I hear there are 3 ways to accomplish this:
> 1) during PostgreSQL configure/build (installation level)
> 2) during initdb (cluster level)
> 3) CREATE DATABASE (db level)

Each one of these only sets the default for the one below it.

> ...but there are some "not-so-happy" stories on the net. For
> instance, "it's not 'true' Unicode support when implemented at the db
> level",

That is bogus.

> or "sorting and regex do not work properly with a cluster
> level implementation",

That is true.

 etc. I've read the v7.3 Admin Guide section
> 7.2 Multibyte support... sounds reasonable. So my question is, what
> is the official way to enable "true" Unicode storage and retrieval,
> so that LIKE, sorting, and regex in perl::DBI work properly?

Sorting will not work correctly with Unicode.

> I am a
> tad concerned also that I don't see PostgreSQL mentioned on the
> Unicode products page;

Well, we're also not listed on the ISO 8859 products page, but I don't 
think that matters. :-)

In response to

pgsql-general by date

Next:From: Peter EisentrautDate: 2004-04-27 16:46:02
Subject: Re: pg_restore problem
Previous:From: Richard HuxtonDate: 2004-04-27 15:35:39
Subject: Re: [SQL] query optimizer dont treat correctly OR

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