如何把全角的日文假名转换成相应的半角日文假名?

[hogcheng]

Oracle中有一种转换方法,是TO_SINGLE_BYTE,但是这个方法只把全角的字母和数字转换成相应的半角字母和数字,至于全角的日文假名则无法转换.各位可否提供一种转换方法,多谢!

[scbb]

笨办法
mCharHash = new HashMap();

mCharHash.put("、" , "、" );
mCharHash.put("。" , "。" );
mCharHash.put("「" , "「" );
mCharHash.put("」" , "」" );
mCharHash.put(" " , "　" );

mCharHash.put("-" , "－" );
mCharHash.put("~" , "～" );
mCharHash.put("!" , "！" );
mCharHash.put("@" , "＠" );
mCharHash.put("#" , "＃" );
mCharHash.put("$" , "＄" );
mCharHash.put("%" , "％" );
mCharHash.put("^" , "＾" );
mCharHash.put("&" , "＆" );
mCharHash.put("*" , "＊" );
mCharHash.put("(" , "（" );
mCharHash.put(")" , "）" );
mCharHash.put("_" , "＿" );
mCharHash.put("+" , "＋" );
mCharHash.put("|" , "｜" );
mCharHash.put("\\" , "￥" );
mCharHash.put("=" , "＝" );
mCharHash.put("`" , "‘" );
mCharHash.put("[" , "［" );
mCharHash.put("]" , "］" );
mCharHash.put("{" , "｛" );
mCharHash.put("}" , "｝" );
mCharHash.put("'" , "’" );
mCharHash.put("\"" , "”" );
mCharHash.put(";" , "；" );
mCharHash.put(":" , "：" );
mCharHash.put("/" , "／" );
mCharHash.put("." , "．" );
mCharHash.put("," , "，" );
mCharHash.put("?" , "？" );
mCharHash.put(">" , "＞" );
mCharHash.put("<" , "＜" );

mCharHash.put("1" , "１" );
mCharHash.put("2" , "２" );
mCharHash.put("3" , "３" );
mCharHash.put("4" , "４" );
mCharHash.put("5" , "５" );
mCharHash.put("6" , "６" );
mCharHash.put("7" , "７" );
mCharHash.put("8" , "８" );
mCharHash.put("9" , "９" );
mCharHash.put("0" , "０" );

mCharHash.put("a" , "ａ" );
mCharHash.put("b" , "ｂ" );
mCharHash.put("c" , "ｃ" );
mCharHash.put("d" , "ｄ" );
mCharHash.put("e" , "ｅ" );
mCharHash.put("f" , "ｆ" );
mCharHash.put("g" , "ｇ" );
mCharHash.put("h" , "ｈ" );
mCharHash.put("i" , "ｉ" );
mCharHash.put("j" , "ｊ" );
mCharHash.put("k" , "ｋ" );
mCharHash.put("l" , "ｌ" );
mCharHash.put("m" , "ｍ" );
mCharHash.put("n" , "ｎ" );
mCharHash.put("o" , "ｏ" );
mCharHash.put("p" , "ｐ" );
mCharHash.put("q" , "ｑ" );
mCharHash.put("r" , "ｒ" );
mCharHash.put("s" , "ｓ" );
mCharHash.put("t" , "ｔ" );
mCharHash.put("u" , "ｕ" );
mCharHash.put("v" , "ｖ" );
mCharHash.put("w" , "ｗ" );
mCharHash.put("x" , "ｘ" );
mCharHash.put("y" , "ｙ" );
mCharHash.put("z" , "ｚ" );

mCharHash.put("A" , "Ａ" );
mCharHash.put("B" , "Ｂ" );
mCharHash.put("C" , "Ｃ" );
mCharHash.put("D" , "Ｄ" );
mCharHash.put("E" , "Ｅ" );
mCharHash.put("F" , "Ｆ" );
mCharHash.put("G" , "Ｇ" );
mCharHash.put("H" , "Ｈ" );
mCharHash.put("I" , "Ｉ" );
mCharHash.put("J" , "Ｊ" );
mCharHash.put("K" , "Ｋ" );
mCharHash.put("L" , "Ｌ" );
mCharHash.put("M" , "Ｍ" );
mCharHash.put("N" , "Ｎ" );
mCharHash.put("O" , "Ｏ" );
mCharHash.put("P" , "Ｐ" );
mCharHash.put("Q" , "Ｑ" );
mCharHash.put("R" , "Ｒ" );
mCharHash.put("S" , "Ｓ" );
mCharHash.put("T" , "Ｔ" );
mCharHash.put("U" , "Ｕ" );
mCharHash.put("V" , "Ｖ" );
mCharHash.put("W" , "Ｗ" );
mCharHash.put("X" , "Ｘ" );
mCharHash.put("Y" , "Ｙ" );
mCharHash.put("Z" , "Ｚ" );

然后.......知道了吧？

[gcq]

用VB就可以了