全角转半角

Question

大家好：
有没有人对日文编码比较熟悉的：
半角假名是否包含下的字符：
ｱｲｳｴｵｶｷｸｹｺｻｼｽｾｿﾀﾁﾂﾃﾄﾅﾆﾇﾈﾉﾊﾋﾌﾍﾎﾏﾐﾑﾒﾓﾔﾕﾖﾗﾘﾙﾚﾛﾜｦﾝｧｨｩｪｫｬｭｮｯｰﾞﾟ｡｢｣､･
ｶﾞｷﾞｸﾞｹﾞｺﾞｻﾞｼﾞｽﾞｾﾞｿﾞﾀﾞﾁﾞﾂﾞﾃﾞﾄﾞﾊﾞﾋﾞﾌﾞﾍﾞﾎﾞﾊﾟﾋﾟﾌﾟﾍﾟﾎﾟ （貌似是2个字符组成的）现在要实现半角假名转换成全角假名：
sql语句应该怎么写好呢？其中ｶﾞｷﾞｸﾞｹﾞｺﾞ等要变换成ガ　ギ　グ　ゲ　ゴ。下面的sql语句，貌似太难看的说。SELECT
     NO,
       TRANSLATE(
          TO_MULTI_BYTE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(
                        REPLACE(NAME,'ｶﾞ','ガ'),
                                     'ｷﾞ','ギ'),
                                     'ｸﾞ','グ'),
                                     'ｹﾞ','ゲ'),
                                     'ｺﾞ','ゴ'),
                                     'ｻﾞ','ザ'),
                                     'ｼﾞ','ジ'),
                                     'ｽﾞ','ズ'),
                                     'ｾﾞ','ゼ'),
                                     'ｿﾞ','ゾ'),
                                     'ﾀﾞ','ダ'),
                                     'ﾁﾞ','ヂ'),
                                     'ﾂﾞ','ヅ'),
                                     'ﾃﾞ','デ'),
                                     'ﾄﾞ','ド'),
                                     'ﾊﾞ','バ'),
                                     'ﾋﾞ','ビ'),
                                     'ﾌﾞ','ブ'),
                                     'ﾍﾞ','ベ'),
                                     'ﾎﾞ','ボ'),
                                     'ﾊﾟ','パ'),
                                     'ﾋﾟ','ピ'),
                                     'ﾌﾟ','プ'),
                                     'ﾍﾟ','ペ'),
                                     'ﾎﾟ','ポ')),'ｱｲｳｴｵｶｷｸｹｺｻｼｽｾｿﾀﾁﾂﾃﾄﾅﾆﾇﾈﾉﾊﾋﾌﾍﾎﾏﾐﾑﾒﾓﾔﾕﾖﾗﾘﾙﾚﾛﾜｦﾝｧｨｩｪｫｬｭｮｯｰﾞﾟ｡｢｣､･','アイウエオカキクケコサシスセソタチツテトナニヌネノハヒフヘホマミムメモヤユヨラリルレロワヲンァィゥェォャュョッー゛゜。「」、・')
FROM 
     GEN_SEIGYO_MASTER

Answer 1

oracle中半角全角转换
SELECT To_single_byte('881898?71') FROM dual ---转成半角SELECT To_muil_byte('881898?71') FROM dual-----转成全角length(p1.accounts)!=lengthb(p1.accounts)----此条件是查出哪些记录里含有全角字符
 

Answer 2

To_muil_byte这个是把单字节变成多字节。只对字母和数字起作用。
半角假名已经是多字节了。