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

Problem with locale on Solaris 8.0 intel

From: Victor Wagner <vitus(at)ice(dot)ru>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem with locale on Solaris 8.0 intel
Date: 2001-06-07 13:54:12
Message-ID: Pine.LNX.4.30.0106071728110.15432-100000@party.ice.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
On the the Solaris 8.0 platform,
when database is build using Russian WIN encoding
and initdb performed using LANG=ru_RU.ANSI1251,

some russian letters for instance
"small letter e" and "small letter che"  according
to unicode consortium naming, are considered equal.

so I cannot insert into key field of some table russian words
for this (ETO) and what(CHTO).

Problem doesn't occur on Linux with ru_RU.CP1251 locale

Locale itself is correctly written

perl script
---
use locale;
print  (("\375\362\356" eq "\367\362\356")?1:0,"\n");
----
returns 0 with locale ru_RU.ANSI1251

-- 
Victor Wagner			vitus(at)ice(dot)ru
Chief Technical Officer		Office:7-(095)-748-53-88
Communiware.Net 		Home: 7-(095)-135-46-61
http://www.communiware.net      http://www.ice.ru/~vitus


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-06-07 15:18:03
Subject: SELECT on VIEW returns wrong result, Buffer Leak
Previous:From: Victor WagnerDate: 2001-06-07 13:28:09
Subject: Syntax of stored procedures is not checked

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