The following bug has been logged online:
Bug reference: 2472
Logged by: Boris
Email address: boris_k@iname.com
PostgreSQL version: 8.1.4
Operating system: win2000
Description: Incorrect ILIKE, ~* for Cyrilic symbols.
Details:
Microsoft Windows 2000 [Version 5.00.2195]
PosgreSql 8.1.4
PgAdmin 1.4.2 III
for Cyrilis symbols ~* and ILIKE return wrong result
data base is created by:
initdb.exe -E UTF8 --lc-collate=UTF8 --lc-ctype=UTF8 "c:\Program
Files\PostgreSQL\8.1\basewin1251\"
then...
postmaster.exe -D "c:\Program Files\PostgreSQL\8.1\basewin1251\"
then
connect to server on local w PgAdmin 1.4.2 III
I see db:
CREATE DATABASE postgres
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default;
Go to SQL Query
SELECT upper('ÐÑоÐа ÐÑÐÑÐÑ'), lower('ÐÑоÐа ÐÑÐÑÐÑ'),
'Ð'ILIKE'Ñ'
return incorrect FALSE for last ILIKE
It must be TRUE
ICQ 176869864 for more info