/*
Copyright (C) 2002 MySQL AB
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
package com.mysql.jdbc;
import java.util.Collections;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;
/**
* Mapping between MySQL charset names
* and Java charset names.
*
* I've investigated placing these in a .properties file,
* but unfortunately under most appservers this complicates
* configuration because the security policy needs to be changed
* by the user to allow the driver to read them :(
*
* @author Mark Matthews
*/
public class CharsetMapping {
//~ Static fields/initializers ---------------------------------------------
/**
* Mapping of Java charset names to MySQL charset names
*/
public static final Map JAVA_TO_MYSQL_CHARSET_MAP;
/**
* Mapping of MySQL charset names to Java charset names
*/
public static final Map CHARSETMAP;
/**
* Map/List of multibyte character sets (using MySQL names)
*/
public static final Map MULTIBYTE_CHARSETS;
/**
* Map of MySQL-4.1 charset indexes to Java encoding names
*/
public static final String[] INDEX_TO_CHARSET;
static {
HashMap tempMap = new HashMap();
tempMap.put("usa7", "US-ASCII");
tempMap.put("big5", "Big5");
tempMap.put("gbk", "GBK");
tempMap.put("sjis", "SJIS");
tempMap.put("gb2312", "EUC_CN");
tempMap.put("ujis", "EUC_JP");
tempMap.put("euc_kr", "EUC_KR");
tempMap.put("latin1", "ISO8859_1");
tempMap.put("latin1_de", "ISO8859_1");
tempMap.put("german1", "ISO8859_1");
tempMap.put("danish", "ISO8859_1");
tempMap.put("latin2", "ISO8859_2");
tempMap.put("czech", "ISO8859_2");
tempMap.put("hungarian", "ISO8859_2");
tempMap.put("croat", "ISO8859_2");
tempMap.put("greek", "ISO8859_7");
tempMap.put("hebrew", "ISO8859_8");
tempMap.put("latin5", "ISO8859_9");
tempMap.put("latvian", "ISO8859_13");
tempMap.put("latvian1", "ISO8859_13");
tempMap.put("estonia", "ISO8859_13");
tempMap.put("dos", "Cp437");
tempMap.put("pclatin2", "Cp852");
tempMap.put("cp866", "Cp866");
tempMap.put("koi8_ru", "KOI8_R");
tempMap.put("tis620", "TIS620");
tempMap.put("win1250", "Cp1250");
tempMap.put("win1250ch", "Cp1250");
tempMap.put("win1251", "Cp1251");
tempMap.put("cp1251", "Cp1251");
tempMap.put("win1251ukr", "Cp1251");
tempMap.put("cp1257", "Cp1257");
tempMap.put("macroman", "MacRoman");
tempMap.put("macce", "MacCentralEurope");
tempMap.put("utf8", "UTF-8");
tempMap.put("ucs2", "UnicodeBig");
CHARSETMAP = Collections.unmodifiableMap(tempMap);
HashMap javaToMysqlMap = new HashMap();
Set keySet = CHARSETMAP.keySet();
Iterator keys = keySet.iterator();
while (keys.hasNext()) {
Object mysqlEncodingName = keys.next();
Object javaEncodingName = CHARSETMAP.get(mysqlEncodingName);
//
// Use 'closest' encodings here...as Java encoding names
// overlap with some MySQL character sets.
//
if ("ISO8859_1".equals(javaEncodingName)) {
if ("latin1".equals(mysqlEncodingName)) {
javaToMysqlMap.put(javaEncodingName, mysqlEncodingName);
}
} else if ("ISO8859_2".equals(javaEncodingName)) {
if ("latin2".equals(mysqlEncodingName)) {
javaToMysqlMap.put(javaEncodingName, mysqlEncodingName);
}
}
else if ("ISO8859_13".equals(javaEncodingName)) {
if ("latin7".equals(mysqlEncodingName)) {
javaToMysqlMap.put(javaEncodingName, mysqlEncodingName);
}
} else {
javaToMysqlMap.put(javaEncodingName, mysqlEncodingName);
}
}
JAVA_TO_MYSQL_CHARSET_MAP = Collections.unmodifiableMap(javaToMysqlMap);
//
// Character sets that we can't convert
// ourselves.
//
HashMap tempMapMulti = new HashMap();
tempMapMulti.put("big5", "big5");
tempMapMulti.put("euc_kr", "euc_kr");
tempMapMulti.put("gb2312", "gb2312");
tempMapMulti.put("gbk", "gbk");
tempMapMulti.put("sjis", "sjis");
tempMapMulti.put("ujis", "ujist");
tempMapMulti.put("utf8", "utf8");
tempMapMulti.put("ucs2", "UnicodeBig");
MULTIBYTE_CHARSETS = Collections.unmodifiableMap(tempMapMulti);
INDEX_TO_CHARSET = new String[64];
INDEX_TO_CHARSET[1] = (String) CHARSETMAP.get("big5");
INDEX_TO_CHARSET[2] = (String) CHARSETMAP.get(" czech");
INDEX_TO_CHARSET[3] = (String) CHARSETMAP.get("dec8");
INDEX_TO_CHARSET[4] = (String) CHARSETMAP.get("dos");
INDEX_TO_CHARSET[5] = (String) CHARSETMAP.get("german1");
INDEX_TO_CHARSET[6] = (String) CHARSETMAP.get("hp8");
INDEX_TO_CHARSET[7] = (String) CHARSETMAP.get("koi8_ru");
INDEX_TO_CHARSET[8] = (String) CHARSETMAP.get("latin1");
INDEX_TO_CHARSET[9] = (String) CHARSETMAP.get("latin2");
INDEX_TO_CHARSET[10] = (String) CHARSETMAP.get("swe7");
INDEX_TO_CHARSET[11] = (String) CHARSETMAP.get("usa7");
INDEX_TO_CHARSET[12] = (String) CHARSETMAP.get("ujis");
INDEX_TO_CHARSET[13] = (String) CHARSETMAP.get("sjis");
INDEX_TO_CHARSET[14] = (String) CHARSETMAP.get("cp1251");
INDEX_TO_CHARSET[15] = (String) CHARSETMAP.get("danish");
INDEX_TO_CHARSET[16] = (String) CHARSETMAP.get("hebrew");
INDEX_TO_CHARSET[18] = (String) CHARSETMAP.get("tis620");
INDEX_TO_CHARSET[19] = (String) CHARSETMAP.get("euc_kr");
INDEX_TO_CHARSET[20] = (String) CHARSETMAP.get("estonia");
INDEX_TO_CHARSET[21] = (String) CHARSETMAP.get("hungarian");
INDEX_TO_CHARSET[22] = (String) CHARSETMAP.get("koi8_ukr");
INDEX_TO_CHARSET[23] = (String) CHARSETMAP.get("win1251ukr");
INDEX_TO_CHARSET[24] = (String) CHARSETMAP.get("gb2312");
INDEX_TO_CHARSET[25] = (String) CHARSETMAP.get("greek");
INDEX_TO_CHARSET[26] = (String) CHARSETMAP.get("win1250");
INDEX_TO_CHARSET[27] = (String) CHARSETMAP.get("croat");
INDEX_TO_CHARSET[28] = (String) CHARSETMAP.get("gbk");
INDEX_TO_CHARSET[29] = (String) CHARSETMAP.get("cp1257");
INDEX_TO_CHARSET[30] = (String) CHARSETMAP.get("latin5");
INDEX_TO_CHARSET[31] = (String) CHARSETMAP.get("latin1_de");
INDEX_TO_CHARSET[32] = (String) CHARSETMAP.get("armscii8");
INDEX_TO_CHARSET[33] = (String) CHARSETMAP.get("utf8");
INDEX_TO_CHARSET[34] = (String) CHARSETMAP.get("win1250ch");
INDEX_TO_CHARSET[35] = (String) CHARSETMAP.get("ucs2");
INDEX_TO_CHARSET[36] = (String) CHARSETMAP.get("cp866");
INDEX_TO_CHARSET[37] = (String) CHARSETMAP.get("keybcs2");
INDEX_TO_CHARSET[38] = (String) CHARSETMAP.get("macce");
INDEX_TO_CHARSET[39] = (String) CHARSETMAP.get("macroman");
INDEX_TO_CHARSET[40] = (String) CHARSETMAP.get("pclatin2");
INDEX_TO_CHARSET[41] = (String) CHARSETMAP.get("latvian");
INDEX_TO_CHARSET[42] = (String) CHARSETMAP.get("latvian1");
INDEX_TO_CHARSET[43] = (String) CHARSETMAP.get("maccebin");
INDEX_TO_CHARSET[44] = (String) CHARSETMAP.get("macceciai");
INDEX_TO_CHARSET[45] = (String) CHARSETMAP.get("maccecias");
INDEX_TO_CHARSET[46] = (String) CHARSETMAP.get("maccecsas");
INDEX_TO_CHARSET[47] = (String) CHARSETMAP.get("latin1bin");
INDEX_TO_CHARSET[48] = (String) CHARSETMAP.get("latin1cias");
INDEX_TO_CHARSET[49] = (String) CHARSETMAP.get("latin1csas");
INDEX_TO_CHARSET[50] = (String) CHARSETMAP.get("cp1251bin");
INDEX_TO_CHARSET[51] = (String) CHARSETMAP.get("cp1251cias");
INDEX_TO_CHARSET[52] = (String) CHARSETMAP.get("cp1251csas");
INDEX_TO_CHARSET[53] = (String) CHARSETMAP.get("macromanbin");
INDEX_TO_CHARSET[54] = (String) CHARSETMAP.get("macromancias");
INDEX_TO_CHARSET[55] = (String) CHARSETMAP.get("macromanciai");
INDEX_TO_CHARSET[56] = (String) CHARSETMAP.get("macromancsas");
INDEX_TO_CHARSET[57] = (String) CHARSETMAP.get("cp1256");
INDEX_TO_CHARSET[63] = (String) CHARSETMAP.get("binary");
}
}