charsetmapping.java

mysql集群

package com.meidusa.amoeba.mysql.util;

import com.meidusa.amoeba.util.StringUtil;

public class CharsetMapping {
	public static final String[] INDEX_TO_CHARSET;
	static {	
		INDEX_TO_CHARSET = new String[99];
		INDEX_TO_CHARSET[1] = "big5";
		INDEX_TO_CHARSET[2] = "czech";
		INDEX_TO_CHARSET[3] = "dec8";
		INDEX_TO_CHARSET[4] = "dos";
		INDEX_TO_CHARSET[5] = "german1";
		INDEX_TO_CHARSET[6] = "hp8";
		INDEX_TO_CHARSET[7] = "koi8_ru";
		INDEX_TO_CHARSET[8] = "latin1";
		INDEX_TO_CHARSET[9] = "latin2";
		INDEX_TO_CHARSET[10] = "swe7";
		INDEX_TO_CHARSET[11] = "usa7";
		INDEX_TO_CHARSET[12] = "ujis";
		INDEX_TO_CHARSET[13] = "sjis";
		INDEX_TO_CHARSET[14] = "cp1251";
		INDEX_TO_CHARSET[15] = "danish";
		INDEX_TO_CHARSET[16] = "hebrew";
		INDEX_TO_CHARSET[18] = "tis620";
		INDEX_TO_CHARSET[19] = "euc_kr";
		INDEX_TO_CHARSET[20] = "estonia";
		INDEX_TO_CHARSET[21] = "hungarian";
		INDEX_TO_CHARSET[22] = "koi8_ukr";
		INDEX_TO_CHARSET[23] = "win1251ukr"; 
		INDEX_TO_CHARSET[24] = "gb2312";
		INDEX_TO_CHARSET[25] = "greek";
		INDEX_TO_CHARSET[26] = "win1250";
		INDEX_TO_CHARSET[27] = "croat";
		INDEX_TO_CHARSET[28] = "gbk"; 
		INDEX_TO_CHARSET[29] = "cp1257";
		INDEX_TO_CHARSET[30] = "latin5";
		INDEX_TO_CHARSET[31] = "latin1_de";
		INDEX_TO_CHARSET[32] = "armscii8";
		INDEX_TO_CHARSET[33] = "utf8"; 
		INDEX_TO_CHARSET[34] = "win1250ch";
		INDEX_TO_CHARSET[35] = "ucs2"; 
		INDEX_TO_CHARSET[36] = "cp866";
		INDEX_TO_CHARSET[37] = "keybcs2";
		INDEX_TO_CHARSET[38] = "macce";
		INDEX_TO_CHARSET[39] = "macroman";
		INDEX_TO_CHARSET[40] = "pclatin2";
		INDEX_TO_CHARSET[41] = "latvian";
		INDEX_TO_CHARSET[42] = "latvian1";
		INDEX_TO_CHARSET[43] = "maccebin";
		INDEX_TO_CHARSET[44] = "macceciai";
		INDEX_TO_CHARSET[45] = "maccecias";
		INDEX_TO_CHARSET[46] = "maccecsas";
		INDEX_TO_CHARSET[47] = "latin1bin";
		INDEX_TO_CHARSET[48] = "latin1cias"; 
		INDEX_TO_CHARSET[49] = "latin1csas"; 
		INDEX_TO_CHARSET[50] = "cp1251bin";
		INDEX_TO_CHARSET[51] = "cp1251cias"; 
		INDEX_TO_CHARSET[52] = "cp1251csas"; 
		INDEX_TO_CHARSET[53] = "macromanbin"; 
		INDEX_TO_CHARSET[54] = "macromancias"; 
		INDEX_TO_CHARSET[55] = "macromanciai"; 
		INDEX_TO_CHARSET[56] = "macromancsas"; 
		INDEX_TO_CHARSET[57] = "cp1256";
		INDEX_TO_CHARSET[63] = "binary";
		INDEX_TO_CHARSET[64] = "armscii";
		INDEX_TO_CHARSET[65] = "ascii";
		INDEX_TO_CHARSET[66] = "cp1250";
		INDEX_TO_CHARSET[67] = "cp1256";
		INDEX_TO_CHARSET[68] = "cp866";
		INDEX_TO_CHARSET[69] = "dec8"; 
		INDEX_TO_CHARSET[70] = "greek";
		INDEX_TO_CHARSET[71] = "hebrew";
		INDEX_TO_CHARSET[72] = "hp8"; 
		INDEX_TO_CHARSET[73] = "keybcs2";
		INDEX_TO_CHARSET[74] = "koi8r";
		INDEX_TO_CHARSET[75] = "koi8ukr";
		INDEX_TO_CHARSET[77] = "latin2";
		INDEX_TO_CHARSET[78] = "latin5";
		INDEX_TO_CHARSET[79] = "latin7";
		INDEX_TO_CHARSET[80] = "cp850";
		INDEX_TO_CHARSET[81] = "cp852";
		INDEX_TO_CHARSET[82] = "swe7"; 
		INDEX_TO_CHARSET[83] = "utf8"; 
		INDEX_TO_CHARSET[84] = "big5"; 
		INDEX_TO_CHARSET[85] = "euckr";
		INDEX_TO_CHARSET[86] = "gb2312";
		INDEX_TO_CHARSET[87] = "gbk"; 
		INDEX_TO_CHARSET[88] = "sjis"; 
		INDEX_TO_CHARSET[89] = "tis620";
		INDEX_TO_CHARSET[90] = "ucs2"; 
		INDEX_TO_CHARSET[91] = "ujis"; 
		INDEX_TO_CHARSET[92] = "geostd8";
		INDEX_TO_CHARSET[93] = "geostd8";
		INDEX_TO_CHARSET[94] = "latin1";
		INDEX_TO_CHARSET[95] = "cp932";
		INDEX_TO_CHARSET[96] = "cp932";
		INDEX_TO_CHARSET[97] = "eucjpms";
		INDEX_TO_CHARSET[98] = "eucjpms";
	}
	
	public static byte getCharsetIndex(String charset){
		if(StringUtil.isEmpty(charset)){
			return 0;
		}else{
			charset = charset.toLowerCase().trim();
			if(charset.equalsIgnoreCase("iso_8859_1")){
				charset = "cp1251"; 
			}
			if(charset.equalsIgnoreCase("utf-8")){
				charset = "utf8"; 
			}
			
			for(byte i=1;i<INDEX_TO_CHARSET.length;i++){
				if(INDEX_TO_CHARSET[i]!= null && INDEX_TO_CHARSET[i].equals(charset)){
					return i;
				}
			}
		}
		return 0;
	}
}