From: pginfo <pginfo@t1.unisoftbg.com>
To: Miroslav Šulc <miroslav.sulc@startnet.cz>
Cc: pgsql-sql@postgresql.org
Subject: Re: lower and unicode
Date: Mon, 14 Mar 2005 12:50:56 +0100
Message-ID: <42357AA0.4090303@t1.unisoftbg.com> (raw)
References: <423528B6.2070407@t1.unisoftbg.com>
<42354812.7030106@startnet.cz>
<42355BFC.4080409@t1.unisoftbg.com>
<42356AB5.1010306@startnet.cz>
Hi,
I am using --no-locale by init db.
I readet that if I am using some locale the pg will work very slow.
Have you noticed some speed penalty by using cs_CZ.utf8.
regards,
ivan.
Miroslav Šulc wrote:
> pginfo wrote:
>
>> Hi,
>> I am uusing pg 8.0.1 on FreeBSD 5.3 but I am ready t use the version
>> taht supports correct unicode.
>
>
> I think that should be fine. I use PostgreSQL 8.0.1 on Linux (Gentoo)
> without these problems (I used cs_CZ.utf8 to init my db). What you
> write seems to me that you have your database initialized to something
> else than xy_XY.utf8 which must be used to have databases working
> correctly with UNICODE. Try 'locale -a' and choose your locale that
> has *.utf8 to initialize the database. Then things should be O.K. :-)
>
> I don't remember I've seen some note in documentation that users must
> use for databases the same encoding as they used for initdb. If this
> is true, it would be time saving to mention this in documentation (if
> it is not already there).
>
>>
>> regards,
>> ivan.
>
>
> Miroslav
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pginfo@t1.unisoftbg.com, miroslav.sulc@startnet.cz
Subject: Re: lower and unicode
In-Reply-To: <42357AA0.4090303@t1.unisoftbg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox