Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql lower different than Java toLowerCase()

577784May 15 2007 — edited May 16 2007
I'm getting different results from Java's toLowerCase() function compared with Oracle's lower. Specifically it appears that in a windows-1252 DB the latin capital letter Z with caron does not get lowercased to it's equivalent (but does in Java):

Ž (142) --> ž (158)

Also, in a windows-1251 DB the cyrillic capital letter ghe with upturn does not get lowercased to it's equivalent (but does in Java):

Ґ (165) --> ґ (180)

Using Locale builder I can create a new characters set which is based on windows-1251 or 1252 and add the correct lower and upper case mappings, however I would like to modify the existing character set definition to include the new mapping. Anyone have any ideas?

Is it possible to add a new lower to upper case / upper to lower case mapping to an existing character set (such as windows-1252 or 1251)?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2007
Added on May 15 2007
4 comments
2,469 views