471,092 Members | 1,480 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

case insensetive UTF-8

lis

Hi!

I need have records on different languages simultaneously on some DB
for i18n of my application. Application is multilingual.
I decide use for this UNICODE. (UNICODE is encoding for my cluster)
But PostgreSQL do not work properly with UNICODE :(
I have the following problems:
1) ORDER BY is not alphabetical, sorting is by symbol code :(
2) ILIKE do not work case insensitive, it is work case sensitive
3) ~* work case sensitive
4) do not work UPPER() and LOWER() functions

I suppose all of this problems has some basis.
Possible Postgres can not do Unicode Collation and Case Mappings
correctly :(

For example:
If I have ru_RU.UNOCODE for DB, then ORDER BY and ILIKE work properly
for KOI8 charset. But UPPER() and LOWER() do not work still.

If I have KOI8 for cluster all work good (ILIKE, ~*, upper()/lower())

But solution with KOI8 for cluster or ru_RU.UNOCODE is not appropriate
for my application, because I need have many encodings on some DB simultaneously.
I think it is bug.

How can I fix this currently?

Will be it fixed on future versions and which version of PostgreSQL will work with
UNICODE correctly?

The same question is present in mailing list
http://archives.postgresql.org/pgsql...3/msg00167.php
but it is unreciprocated.
Best regards,
Alexander Litvin.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
0 1453

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by siliconmike | last post: by
10 posts views Thread by jose.jeria | last post: by
1 post views Thread by Dean Slindee | last post: by
23 posts views Thread by Allan Ebdrup | last post: by
2 posts views Thread by Clodoaldo | last post: by
1 post views Thread by Andy Fish | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.