How to compare japanese katakana full/half width characters in oracle
649219Jul 9 2008 — edited May 14 2010After set NLS_Sort=Japanese_M_CI NLS_Comp=Linguistic
I seems that most of the full width katakana characters and their corresponding half width characters are compared as equal. E.g.
'ハロタン' (full width) vs. 'ﾊﾛﾀﾝ' (half).
But I notice that some characters like the following are not equal:
'ペ'(full width) vs 'ﾍﾟ'(half width)
My understanding is that some full width characters become two half width characters. In my example, the circle part of the character doesn't have meaning in full width, but can be independent in half width.
It's touch since I don't understand Japanese. Any suggestion to make then compare correctly in oracle is greatly appreciated.