Re: [GENERAL] postgresql unicode lower/upper problem
I modify pg_createcluster and add locale options exec $initdb, '--locale', 'ru_RU.UTF-8', '--encoding', 'UTF-8', '-D', $datadir then drop and create cluster with my locale. now lower and upper work good with unicode. P.S. it's bad that we can not modify lc_ctype and lc_collate from postgresql.conf like lc_messages, lc_monetary, ... I think that it will be good idea to add locale specific options to pg_createcluster... On Wed, 23 Mar 2005 12:17:14 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Sergey Levchenko <[EMAIL PROTECTED]> writes: > > I am not able to get work lower and upper functions on postgresql > > v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux. > > Locale: ru_RU.KOI8-R > > > createdb -E UNICODE test > > I think the problem is you selected a database encoding that doesn't > match what the locale expects. You can't really mix-and-match if you > expect locale-specific stuff like upper/lower to work. For that > locale you must use -E KOI8. > > regards, tom lane > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] postgresql unicode lower/upper problem
Sergey Levchenko <[EMAIL PROTECTED]> writes: > I am not able to get work lower and upper functions on postgresql > v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux. > Locale: ru_RU.KOI8-R > createdb -E UNICODE test I think the problem is you selected a database encoding that doesn't match what the locale expects. You can't really mix-and-match if you expect locale-specific stuff like upper/lower to work. For that locale you must use -E KOI8. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] postgresql unicode lower/upper problem
I am not able to get work lower and upper functions on postgresql v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux. Locale: ru_RU.KOI8-R createdb -E UNICODE test psql test test=> SET client_encoding TO KOI8; SET test=> SELECT t FROM t1; t ÐÐ tEsT (2 rows) test=> SELECT upper(t) FROM t1; upper ÐÐ TEST test=> SELECT lower(t) FROM t1; lower ÐÐ test (2 rows) How you can see it work perfect with latin and does not do any lower/upper with koi8. what I do wrong? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster