Collation issue with Japanese characters (encoding utf-8) in Oracle8i

• Previous message: Jim Allan: "Re: Default Collation"
• In reply to: Jim Allan: "Re: Default Collation"
• Next in thread: Jianping Yang: "Re: Collation issue with Japanese characters (encoding utf-8) in Oracle8i"
• Reply: Jianping Yang: "Re: Collation issue with Japanese characters (encoding utf-8) in Oracle8i"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
• Mail actions: [ respond to this message ] [ mail a new topic ]

Hi,

I have japanese data in a varchar2 column in an Oracle8i instance which contains both single byte and multibyte Japanese characters. The encoding type of the instance is UTF-8.

I want to sort them in such a way that equivalent single byte and multibyte Japanese characters are treated as same. Also while selecting, if I specify the single byte characters in the where condition it should select both single and double byte characters and vice-versa.

The functionality I'm looking for is similar to the one which can be achieved by using Collator class in Java with FULL_DECOMPOSITION as decmposition mode.

Could anyone please let me know how can I do it ?

Thanks in advance.

Best Regards,
Sourav

Catch all the cricket action. Download Yahoo! Score tracker

• Next message: Jianping Yang: "Re: Collation issue with Japanese characters (encoding utf-8) in Oracle8i"
• Previous message: Jim Allan: "Re: Default Collation"
• In reply to: Jim Allan: "Re: Default Collation"
• Next in thread: Jianping Yang: "Re: Collation issue with Japanese characters (encoding utf-8) in Oracle8i"
• Reply: Jianping Yang: "Re: Collation issue with Japanese characters (encoding utf-8) in Oracle8i"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
• Mail actions: [ respond to this message ] [ mail a new topic ]

This archive was generated by hypermail 2.1.5 : Fri Jan 10 2003 - 00:19:38 EST