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



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
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.