aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPDatabaseCharacterSets.m
diff options
context:
space:
mode:
Diffstat (limited to 'Source/SPDatabaseCharacterSets.m')
-rw-r--r--Source/SPDatabaseCharacterSets.m967
1 files changed, 967 insertions, 0 deletions
diff --git a/Source/SPDatabaseCharacterSets.m b/Source/SPDatabaseCharacterSets.m
new file mode 100644
index 00000000..a6fd79a2
--- /dev/null
+++ b/Source/SPDatabaseCharacterSets.m
@@ -0,0 +1,967 @@
+//
+// $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;
+}
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-09 21:49:17 +0000