DB内の項目の半角全角を変換する。

年末アップしようと思って忘れてたので。
postgresqlのtranslate関数は、複数の文字を変換することができるので、
１文字対１文字の変換であれば、文字に限らず数字アルファベットも１文ですべて変換してしまうことができます。

問題は濁点、半濁点まじりの文字の場合。
これは1文字対1文字の置き換えではないので、replace関数を順番に適用していくしかないです。
この際注意しないといけないのが、WHERE句の指定で、これが無いとすべての行に対してUPDATEが走ってしまうので、
件数が２桁万件くらいになるとpostgresqlの場合パフォーマンスで問題が出ます。
というわけでコピペ用コードは以下。[table_name]、[column_name]を適切なテーブル名とカラム名に置き換えてくださいな。

UPDATE [table_name] SET [column_name] = replace([column_name],'ｶﾞ','ガ') WHERE [column_name] LIKE '%ｶﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｷﾞ','ギ') WHERE [column_name] LIKE '%ｷﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｸﾞ','グ') WHERE [column_name] LIKE '%ｸﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｹﾞ','ゲ') WHERE [column_name] LIKE '%ｹﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｺﾞ','ゴ') WHERE [column_name] LIKE '%ｺﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｻﾞ','ザ') WHERE [column_name] LIKE '%ｻﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｼﾞ','ジ') WHERE [column_name] LIKE '%ｼﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｽﾞ','ズ') WHERE [column_name] LIKE '%ｽﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｾﾞ','ゼ') WHERE [column_name] LIKE '%ｾﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｿﾞ','ゾ') WHERE [column_name] LIKE '%ｿﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾀﾞ','ダ') WHERE [column_name] LIKE '%ﾀﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾁﾞ','ヂ') WHERE [column_name] LIKE '%ﾁﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾂﾞ','ヅ') WHERE [column_name] LIKE '%ﾂﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾃﾞ','デ') WHERE [column_name] LIKE '%ﾃﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾄﾞ','ド') WHERE [column_name] LIKE '%ﾄﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾊﾞ','バ') WHERE [column_name] LIKE '%ﾊﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾋﾞ','ビ') WHERE [column_name] LIKE '%ﾋﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾌﾞ','ブ') WHERE [column_name] LIKE '%ﾌﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾍﾞ','ベ') WHERE [column_name] LIKE '%ﾍﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾎﾞ','ボ') WHERE [column_name] LIKE '%ﾎﾞ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾊﾟ','パ') WHERE [column_name] LIKE '%ﾊﾟ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾋﾟ','ピ') WHERE [column_name] LIKE '%ﾋﾟ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾌﾟ','プ') WHERE [column_name] LIKE '%ﾌﾟ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾍﾟ','ペ') WHERE [column_name] LIKE '%ﾍﾟ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ﾎﾟ','ポ') WHERE [column_name] LIKE '%ﾎﾟ%';
UPDATE [table_name] SET [column_name] = replace([column_name],'ｳﾞ','ヴ') WHERE [column_name] LIKE '%ｳﾞ%';
UPDATE [table_name] SET [column_name] = translate([column_name],'ｱｲｳｴｵｶｷｸｹｺｻｼｽｾｿﾀﾁﾂﾃﾄﾅﾆﾇﾈﾉﾊﾋﾌﾍﾎﾏﾐﾑﾒﾓﾔﾕﾖﾗﾘﾙﾚﾛﾜｦﾝ','アイウエオカキクケコサシスセソタチツテトナニヌネノハヒフヘホマミムメモヤユヨラリルレロワヲン');

これってmysqlとかsqlserverとかやったらどうなるんだろう？
簡単関数あるのだろうか！