//
//  $Id$
//
//  SPDatabaseCharacaterSets.m
//  sequel-pro
//
//  Created by Stuart Connolly (stuconnolly.com) on October 7, 2010
//  Copyright (c) 2010 Stuart Connolly. All rights reserved.
//
//  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
//
//  More info at <http://code.google.com/p/sequel-pro/>

#import "SPDatabaseCharacterSets.h"

/**
 * List of hardcoded character sets and associated collations. Used for older (i.e. Mysql 3 & 4) servers.
 */
const SPDatabaseCharSets charsets[] =
{
	{
		1, 
		"big5", 
		"big5_chinese_ci", 
		"Big5 Traditional Chinese"
	},
	{
		3, 
		"dec8",
		"dec8_swedisch_ci", 
		"DEC West European"
	},
	{
		4,
		"cp850",
		"cp850_general_ci",
		"DOS West European"
	},
	{
		6,
		"hp8",
		"hp8_english_ci",
		"HP West European"
	},
	{
		7,
		"koi8r",
		"koi8r_general_ci",
		"KOI8-R Relcom Russian"
	},
	{
		8,
		"latin1",
		"latin1_swedish_ci",
		"cp1252 West European"
	},
	{
		9,
		"latin2",
		"latin2_general_ci",
		"ISO 8859-2 Central European"
	},
	{ 
		10,
		"swe7",
		"swe7_swedish_ci",
		"7bit Swedish"
	},
	{
		11,
		"ascii",
		"ascii_general_ci",
		"US ASCII"
	},
	{
		12,
		"ujis",
		"ujis_japanese_ci",
		"EUC-JP Japanese"
	},
	{
		13,
		"sjis",
		"sjis_japanese_ci",
		"Shift-JIS Japanese"
	},
	{
		16,
		"hebrew",
		"hebrew_general_ci",
		"ISO 8859-8 Hebrew"
	},
	{
		18,
		"tis620",
		"tis620_thai_ci",
		"TIS620 Thai"
	},
	{
		19,
		"euckr",
		"euckr_korean_ci",
		"EUC-KR Korean"
	},
	{
		22,
		"koi8u",
		"koi8u_general_ci",
		"KOI8-U Ukrainian"
	},
	{
		24,
		"gb2312",
		"gb2312_chinese_ci",
		"GB2312 Simplified Chinese"
	},
	{
		25,
		"greek",
		"greek_general_ci",
		"ISO 8859-7 Greek"
	},
	{
		26,
		"cp1250",
		"cp1250_general_ci",
		"Windows Central European"
	},
	{
		28,
		"gbk",
		"gbk_chinese_ci",
		"GBK Simplified Chinese"
	},
	{
		30,
		"latin5",
		"latin5_turkish_ci",
		"ISO 8859-9 Turkish"
	},
	{
		32,
		"armscii8",
		"armscii8_general_ci",
		"ARMSCII-8 Armenian"
	},
	{
		33,
		"utf8",
		"utf8_general_ci",
		"UTF-8 Unicode"
	},
	{
		35,
		"ucs2",
		"ucs2_general_ci",
		"UCS-2 Unicode"
	},
	{
		36,
		"cp866",
		"cp866_general_ci",
		"DOS Russian"
	},
	{
		37,
		"keybcs2",
		"keybcs2_general_ci",
		"DOS Kamenicky Czech-Slovak"
	},
	{
		38,
		"macce",
		"macce_general_ci",
		"Mac Central European"
	},
	{
		39,
		"macroman",
		"macroman_general_ci",
		"Mac West European"
	},
	{
		40,
		"cp852",
		"cp852_general_ci",
		"DOS Central European"
	},
	{
		41,
		"latin7",
		"latin7_general_ci",
		"ISO 8859-13 Baltic"
	},
	{
		51,
		"cp1251",
		"cp1251_general_ci",
		"Windows Cyrillic"
	},
	{
		57,
		"cp1256",
		"cp1256_general_ci",
		"Windows Arabic"
	},
	{
		59,
		"cp1257",
		"cp1257_general_ci",
		"Windows Baltic"
	},
	{
		63,
		"binary",
		"binary",
		"Binary pseudo charset"
	},
	{
		92,
		"geostd8",
		"geostd8_general_ci",
		"GEOSTD8 Georgian"
	},
	{
		95,
		"cp932",
		"cp932_japanese_ci",
		"SJIS for Windows Japanese"
	},
	{
		97,
		"eucjpms",
		"eucjpms_japanese_ci",
		"UJIS for Windows Japanese"
	},
	{
		2,
		"latin2",
		"latin2_czech_cs",
		"ISO 8859-2 Central European"
	},
	{
		5,
		"latin1",
		"latin1_german_ci",
		"cp1252 West European"
	},
	{
		14,
		"cp1251",
		"cp1251_bulgarian_ci",
		"Windows Cyrillic"
	},
	{
		15,
		"latin1",
		"latin1_danish_ci",
		"cp1252 West European"
	},
	{
		17,
		"filename",
		"filename",
		"File Name"
	},
	{
		20,
		"latin7",
		"latin7_estonian_cs",
		"ISO 8859-13 Baltic"
	},
	{
		21,
		"latin2",
		"latin2_hungarian_ci",
		"ISO 8859-2 Central European"
	},
	{
		23,
		"cp1251",
		"cp1251_ukrainian_ci",
		"Windows Cyrillic"
	},
	{
		27,
		"latin2",
		"latin2_croatian_ci",
		"ISO 8859-2 Central European"
	},
	{
		29,
		"cp1257",
		"cp1257_lithunian_ci",
		"Windows Baltic"
	},
	{
		31,
		"latin1",
		"latin1_german2_ci",
		"cp1252 West European"
	},
	{
		34,
		"cp1250",
		"cp1250_czech_cs",
		"Windows Central European"
	},
	{
		42,
		"latin7",
		"latin7_general_cs",
		"ISO 8859-13 Baltic"
	},
	{
		43,
		"macce",
		"macce_bin",
		"Mac Central European"
	},
	{
		44,
		"cp1250",
		"cp1250_croatian_ci",
		"Windows Central European"
	},
	{
		45,
		"utf8",
		"utf8_general_ci",
		"UTF-8 Unicode"
	},
	{
		46,
		"utf8",
		"utf8_bin",
		"UTF-8 Unicode"
	},
	{
		47,
		"latin1",
		"latin1_bin",
		"cp1252 West European"
	},
	{
		48,
		"latin1",
		"latin1_general_ci",
		"cp1252 West European"
	},
	{
		49,
		"latin1",
		"latin1_general_cs",
		"cp1252 West European"
	},
	{
		50,
		"cp1251",
		"cp1251_bin",
		"Windows Cyrillic"
	},
	{
		52,
		"cp1251",
		"cp1251_general_cs",
		"Windows Cyrillic"
	},
	{
		53,
		"macroman",
		"macroman_bin",
		"Mac West European"
	},
	{
		58,
		"cp1257",
		"cp1257_bin",
		"Windows Baltic"
	},
	{
		60,
		"armascii8",
		"armascii8_bin",
		"armascii8"
	},
	{
		65,
		"ascii",
		"ascii_bin",
		"US ASCII"
	},
	{
		66,
		"cp1250",
		"cp1250_bin",
		"Windows Central European"
	},
	{
		67,
		"cp1256",
		"cp1256_bin",
		"Windows Arabic"
	},
	{
		68,
		"cp866",
		"cp866_bin",
		"DOS Russian"
	},
	{
		69,
		"dec8",
		"dec8_bin",
		"DEC West European"
	},
	{
		70,
		"greek",
		"greek_bin",
		"ISO 8859-7 Greek"
	},
	{
		71,
		"hebew",
		"hebrew_bin",
		"ISO 8859-8 Hebrew"
	},
	{
		72,
		"hp8",
		"hp8_bin",
		"HP West European"
	},
	{
		73,
		"keybcs2",
		"keybcs2_bin",
		"DOS Kamenicky Czech-Slovak"
	},
	{
		74,
		"koi8r",
		"koi8r_bin",
		"KOI8-R Relcom Russian"
	},
	{
		75,
		"koi8u",
		"koi8u_bin",
		"KOI8-U Ukrainian"
	},
	{
		77,
		"latin2",
		"latin2_bin",
		"ISO 8859-2 Central European"
	},
	{
		78,
		"latin5",
		"latin5_bin",
		"ISO 8859-9 Turkish"
	},
	{
		79,
		"latin7",
		"latin7_bin",
		"ISO 8859-13 Baltic"
	},
	{
		80,
		"cp850",
		"cp850_bin",
		"DOS West European"
	},
	{
		81,
		"cp852",
		"cp852_bin",
		"DOS Central European"
	},
	{
		82,
		"swe7",
		"swe7_bin",
		"7bit Swedish"
	},
	{
		93,
		"geostd8",
		"geostd8_bin",
		"GEOSTD8 Georgian"
	},
	{
		83,
		"utf8",
		"utf8_bin",
		"UTF-8 Unicode"
	},
	{
		84,
		"big5",
		"big5_bin",
		"Big5 Traditional Chinese"
	},
	{
		85,
		"euckr",
		"euckr_bin",
		"EUC-KR Korean"
	},
	{
		86,
		"gb2312",
		"gb2312_bin",
		"GB2312 Simplified Chinese"
	},
	{
		87,
		"gbk",
		"gbk_bin",
		"GBK Simplified Chinese"
	},
	{
		88,
		"sjis",
		"sjis_bin",
		"Shift-JIS Japanese"
	},
	{
		89,
		"tis620",
		"tis620_bin",
		"TIS620 Thai"
	},
	{
		90,
		"ucs2",
		"ucs2_bin",
		"UCS-2 Unicode"
	},
	{
		91,
		"ujis",
		"ujis_bin",
		"EUC-JP Japanese"
	},
	{
		94,
		"latin1",
		"latin1_spanish_ci",
		"cp1252 West European"
	},
	{
		96,
		"cp932",
		"cp932_bin",
		"SJIS for Windows Japanese"
	},
	{
		99,
		"cp1250",
		"cp1250_polish_ci",
		"Windows Central European"
	},
	{
		98,
		"eucjpms",
		"eucjpms_bin",
		"UJIS for Windows Japanese"
	},
	{
		128,
		"ucs2",
		"ucs2_unicode_ci",
		"UCS-2 Unicode"
	},
	{
		129,
		"ucs2",
		"ucs2_icelandic_ci",
		"UCS-2 Unicode"
	},
	{
		130,
		"ucs2",
		"ucs2_latvian_ci",
		"UCS-2 Unicode"
	},
	{
		131,
		"ucs2",
		"ucs2_romanian_ci",
		"UCS-2 Unicode"
	},
	{
		132,
		"ucs2",
		"ucs2_slovenian_ci",
		"UCS-2 Unicode"
	},
	{
		133,
		"ucs2",
		"ucs2_polish_ci",
		"UCS-2 Unicode"
	},
	{
		134,
		"ucs2",
		"ucs2_estonian_ci",
		"UCS-2 Unicode"
	},
	{
		135,
		"ucs2",
		"ucs2_spanish_ci",
		"UCS-2 Unicode"
	},
	{
		136,
		"ucs2",
		"ucs2_swedish_ci",
		"UCS-2 Unicode"
	},
	{
		137,
		"ucs2",
		"ucs2_turkish_ci",
		"UCS-2 Unicode"
	},
	{
		138,
		"ucs2",
		"ucs2_czech_ci",
		"UCS-2 Unicode"
	},
	{
		139,
		"ucs2",
		"ucs2_danish_ci",
		"UCS-2 Unicode"
	},
	{
		140,
		"ucs2",
		"ucs2_lithunian_ci",
		"UCS-2 Unicode"
	},
	{
		141,
		"ucs2",
		"ucs2_slovak_ci",
		"UCS-2 Unicode"
	},
	{
		142,
		"ucs2",
		"ucs2_spanish2_ci",
		"UCS-2 Unicode"
	},
	{
		143,
		"ucs2",
		"ucs2_roman_ci",
		"UCS-2 Unicode"
	},
	{
		144,
		"ucs2",
		"ucs2_persian_ci",
		"UCS-2 Unicode"
	},
	{
		145,
		"ucs2",
		"ucs2_esperanto_ci",
		"UCS-2 Unicode"
	},
	{
		146,
		"ucs2",
		"ucs2_hungarian_ci",
		"UCS-2 Unicode"
	},
	{
		147,
		"ucs2",
		"ucs2_sinhala_ci",
		"UCS-2 Unicode"
	},
	{
		192,
		"utf8mb3",
		"utf8mb3_general_ci",
		"UTF-8mb3 Unicode"
	},
	{
		193,
		"utf8mb3",
		"utf8mb3_icelandic_ci",
		"UTF-8mb3 Unicode"
	},
	{
		194,
		"utf8mb3",
		"utf8mb3_latvian_ci",
		"UTF-8mb3 Unicode"
	},
	{
		195,
		"utf8mb3",
		"utf8mb3_romanian_ci",
		"UTF-8mb3 Unicode"
	},
	{
		196,
		"utf8mb3",
		"utf8mb3_slovenian_ci",
		"UTF-8mb3 Unicode"
	},
	{
		197,
		"utf8mb3",
		"utf8mb3_polish_ci",
		"UTF-8mb3 Unicode"
	},
	{
		198,
		"utf8mb3",
		"utf8mb3_estonian_ci",
		"UTF-8mb3 Unicode"
	},
	{
		119,
		"utf8mb3",
		"utf8mb3_spanish_ci",
		"UTF-8mb3 Unicode"
	},
	{
		200,
		"utf8mb3",
		"utf8mb3_swedish_ci",
		"UTF-8mb3 Unicode"
	},
	{
		201,
		"utf8mb3",
		"utf8mb3_turkish_ci",
		"UTF-8mb3 Unicode"
	},
	{
		202,
		"utf8mb3",
		"utf8mb3_czech_ci",
		"UTF-8mb3 Unicode"
	},
	{
		203,
		"utf8mb3",
		"utf8mb3_danish_ci",
		"UTF-8mb3 Unicode"
	},
	{
		204,
		"utf8mb3",
		"utf8mb3_lithunian_ci",
		"UTF-8mb3 Unicode"
	},
	{
		205,
		"utf8mb3",
		"utf8mb3_slovak_ci",
		"UTF-8mb3 Unicode"
	},
	{
		206,
		"utf8mb3",
		"utf8mb3_spanish2_ci",
		"UTF-8mb3 Unicode"
	},
	{
		207,
		"utf8mb3",
		"utf8mb3_roman_ci",
		"UTF-8mb3 Unicode"
	},
	{
		208,
		"utf8mb3",
		"utf8mb3_persian_ci",
		"UTF-8mb3 Unicode"
	},
	{
		209,
		"utf8mb3",
		"utf8mb3_esperanto_ci",
		"UTF-8mb3 Unicode"
	},
	{
		210,
		"utf8mb3",
		"utf8mb3_hungarian_ci",
		"UTF-8mb3 Unicode"
	},
	{
		211,
		"utf8mb3",
		"utf8mb3_sinhala_ci",
		"UTF-8mb3 Unicode"
	},
	{
		224,
		"utf8",
		"utf8_unicode_ci",
		"UTF-8 Unicode"
	},
	{
		225,
		"utf8",
		"utf8_icelandic_ci",
		"UTF-8 Unicode"
	},
	{
		226,
		"utf8",
		"utf8_latvian_ci",
		"UTF-8 Unicode"
	},
	{
		227,
		"utf8",
		"utf8_romanian_ci",
		"UTF-8 Unicode"
	},
	{
		228,
		"utf8",
		"utf8_slovenian_ci",
		"UTF-8 Unicode"
	},
	{
		229,
		"utf8",
		"utf8_polish_ci",
		"UTF-8 Unicode"
	},
	{
		230,
		"utf8",
		"utf8_estonian_ci",
		"UTF-8 Unicode"
	},
	{
		231,
		"utf8",
		"utf8_spanish_ci",
		"UTF-8 Unicode"
	},
	{
		232,
		"utf8",
		"utf8_swedish_ci",
		"UTF-8 Unicode"
	},
	{
		233,
		"utf8",
		"utf8_turkish_ci",
		"UTF-8 Unicode"
	},
	{
		234,
		"utf8",
		"utf8_czech_ci",
		"UTF-8 Unicode"
	},
	{
		235,
		"utf8",
		"utf8_danish_ci",
		"UTF-8 Unicode"
	},
	{
		236,
		"utf8",
		"utf8_lithuanian_ci",
		"UTF-8 Unicode"
	},
	{
		237,
		"utf8",
		"utf8_slovak_ci",
		"UTF-8 Unicode"
	},
	{
		238,
		"utf8",
		"utf8_spanish2_ci",
		"UTF-8 Unicode"
	},
	{
		239,
		"utf8",
		"utf8_roman_ci",
		"UTF-8 Unicode"
	},
	{
		240,
		"utf8",
		"utf8_persian_ci",
		"UTF-8 Unicode"
	},
	{
		241,
		"utf8",
		"utf8_esperanto_ci",
		"UTF-8 Unicode"
	},
	{
		242,
		"utf8",
		"utf8_hungarian_ci",
		"UTF-8 Unicode"
	},
	{
		243,
		"utf8",
		"utf8_sinhala_ci",
		"UTF-8 Unicode"
	},
	{
		254,
		"utf8mb3",
		"utf8mb3_general_cs",
		"UTF-8mb3 Unicode"
	},
	{
		0,
		NULL,
		NULL,
		NULL
	}
};

/**
 * Simply returns the above character set data struct.
 *
 * @return Characater set data struct of type SPDatabaseCharSets
 */
const SPDatabaseCharSets *SPGetDatabaseCharacterSets(void)
{	
	return charsets;
}