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

unicode regular insensitive matching 2.

From: Jan Poslusny <pajout(at)gingerall(dot)cz>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: unicode regular insensitive matching 2.
Date: 2001-06-29 08:55:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I used czech locales, described in attached pg_bash_profile exactly, 
briefly here:

I used unicodeSQL script for db with UNICODE charset and latin2SQL 
script for db with LATIN2 charset. I hope attached scripts are 

I don't know, what is misconfigured or badly used.

thanks for some hint

Peter Eisentraut wrote:

> Jan Poslusny writes:
>>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)
> Unicode is only a character set.  Issues like sorting and letter-case are
> determined by the locale.  You didn't say which locale you used or wanted
> to use, what your input was and what ordering you expected, so there's not
> a lot we can do for you.

Attachment: pg_bash_profile
Description: text/plain (780 bytes)
Attachment: unicodeSQL
Description: application/octet-stream (859 bytes)
Attachment: latin2SQL
Description: application/octet-stream (854 bytes)

In response to

pgsql-general by date

Next:From: IgorDate: 2001-06-29 08:56:46
Subject: Re: Vs: How to check connection?
Previous:From: Feite BrekeveldDate: 2001-06-29 08:54:09
Subject: Re: Trigger

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