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

unicode regular insensitive matching

From: Jan Poslusny <pajout(at)gingerall(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: unicode regular insensitive matching
Date: 2001-06-28 18:41:04
Message-ID: (view raw or whole thread)
Lists: pgsql-general

-------- Original Message --------
Subject: unicode regular insensitive matching
Date: Thu, 28 Jun 2001 20:32:08 +0200
From: Jan Poslusny <pajout(at)gingerall(dot)cz>
Organization: Ginger Alliance
To: pgsql-general(at)postgresql

I am newbie in postgreSQL and I have this problem with 7.1.2 version:
I configured via
then I succesfully gmake, gmake check, gmake install,
then I initdb -E UNICODE,
then I createdb -E UNICODE.


select myfield from mytable where myfield ~* 'MiXeD national-specific 
characters' order by myfield

is _NOT_ case insensitive and not ordered according to locales (if I
create another db with LATIN2 charset, all is OK)

Can anybody hint me ?


pgsql-general by date

Next:From: Joseph ShraibmanDate: 2001-06-28 18:47:50
Subject: Re: Weird error
Previous:From: Mihai GheorghiuDate: 2001-06-28 18:23:16
Subject: Exporting data from MSAccess to PostgreSQL

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