Re: PostgreSQL - Mailing list pgsql-general

From Alexander Litvinov
Subject Re: PostgreSQL
Date
Msg-id 200308111035.12364.lan@ac-sw.com
Whole thread Raw
In response to Re: PostgreSQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: PostgreSQL
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I confirm this behavour: cyrilic words are not changed by lower()/upper()
functions, nor catched by ilike.

I am using :
=> SELECT version();
                            version
- ---------------------------------------------------------------
 PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2
(1 row)

Nothing special was done during database creation (no encoding selected).

> Not sure.  I thought it would work.

> > How to use string functions (like UPPER()/LOWER()) for non-latin strings?
> > Why UPPER() function doesn't work with my UNICODE PostgreSQL database
> > which contains non-latin characters (like cyrillic)? How to make case
> > insensetive search by text field which contains non-latin characters?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/Nw7wV+WKOINIfOYRAuhmAJwMEkdgqXkt6ZhgJsFZfQH2mELRwgCfeDeV
L9TbSItEb0tAC7cI0cKwg6A=
=veHN
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL
Next
From: Mat
Date:
Subject: Tsearch limitations