<< Click to Display Table of Contents >>

Character sets and available alias

Character sets available for encoding and decoding set of database connection are listed. And alias names for each character set also listed.

Character sets

Available alias

ASCII

us-ascii, ascii, 646, iso646-us, default, ascii7

Big5

big5

Cp037

ibm037, ibm-037, cp037, 037

Cp1006

ibm1006, ibm-1006, cp1006, 1006

Cp1025

ibm1025, ibm-1025, cp1025, 1025

Cp1026

ibm1026, ibm-1026, cp1026, 1026

Cp1097

ibm1097, ibm-1097, cp1097, 1097

Cp1098

ibm1098, ibm-1098, cp1098, 1098

Cp1112

ibm1112, ibm-1112, cp1112, 1112

Cp1122

ibm1122, ibm-1122, cp1122, 1122

Cp1123

ibm1123, ibm-1123, cp1123, 1123

Cp1124

ibm1124, ibm-1124, cp1124, 1124

Cp1250

windows-1250

Cp1251

windows-1251

Cp1252

windows-1252

Cp1253

windows-1253

Cp1254

windows-1254

Cp1255

windows-1255

Cp1256

windows-1256

Cp1257

windows-1257

Cp1258

windows-1258

Cp1381

ibm1381, ibm-1381, cp1381, 1381

Cp1383

ibm1383, ibm-1383, cp1383, 1383

Cp273

ibm273, ibm-273, cp273, 273

Cp277

ibm277, ibm-277, cp277, 277

Cp278

ibm278, ibm-278, cp278, 278

Cp280

ibm280, ibm-280, cp280, 280

Cp284

ibm284, ibm-284, cp284, 284

Cp285

ibm285, ibm-285, cp285, 285

Cp297

ibm297, ibm-297, cp297, 297

Cp33722

Ibm33722, ibm-33722, cp33722, 33722

Cp420

ibm420, ibm-420, cp420, 420

Cp424

ibm424, ibm-424, cp424, 424

Cp437

ibm437, ibm-437, cp437, 437

Cp500

ibm500, ibm-500, cp500, 500

Cp737

ibm737, ibm-737, cp737, 737

Cp775

ibm775, ibm-775, cp775, 775

Cp838

ibm838, ibm-838, cp838, 838

Cp850

ibm850, ibm-850, cp850, 850, cspc850multilingual

Cp852

ibm852, ibm-852, cp852, 852, cspcp852

Cp855

ibm855, ibm-855, cp855, 855, cspcp855

Cp856

ibm856 ibm-856, cp856 856

Cp857

ibm857, ibm-857, cp857, 857, csibm857

Cp860

ibm860, ibm-860, cp860, 860, csibm860

Cp861

ibm861, ibm-861, cp861, cp-is, 861, csibm861

Cp862

ibm862, ibm-862, cp862, cp862, 862, cspc862latinhebrew

Cp863

ibm863, ibm-863, cp863, 863, csibm863

Cp864

ibm864, ibm-864, cp864, csibm864

Cp865

ibm865, ibm-865, cp865, 865, csibm865

Cp866

ibm866, ibm-866, cp866, 866, csibm866

Cp868

ibm868, ibm-868, cp868, 868

Cp869

ibm869, ibm-869, cp869, 869, cp-gr, csibm869

Cp870

ibm870, ibm-870, cp870, 870

Cp871

ibm871, ibm-871, cp871, 871

Cp874

ibm874, ibm-874, cp874, 874

Cp875

ibm875, ibm-875, cp875, 875

Cp918

ibm918, ibm-918, cp918, 918

Cp921

ibm921, ibm-921, cp921, 921

Cp922

ibm922, ibm-922, cp922, 922

Cp930

ibm930, ibm-930, cp930, 930

Cp933

ibm933, ibm-933, cp933, 933

Cp935

ibm935, ibm-935, cp935, 935

Cp937

ibm937, ibm-937, cp937, 937

Cp939

ibm939, ibm-939, cp939, 939

Cp942

ibm942, ibm-942, cp942, 942

Cp942C

cp942c

Cp943

ibm943, ibm-943, cp943, 943

Cp943C

cp943c

Cp948

ibm948, ibm-948, cp948, 948

Cp949

ibm949, ibm-949, cp949, 949

Cp949C

cp949c

Cp950

ibm950, ibm-950, cp950, 950

Cp964

ibm964, ibm-964, cp964, 964

Cp970

ibm970, ibm-970, cp970, 970

EUC_CN

gb2312, gb2312-80, gb2312-1980, euc-cn, euccn

EUC_JP

eucjis, euc-jp, eucjp, extended_unix_code_packed_format_for_japanese, cseucpkdfmtjapanese, x-euc-jp, x-eucjp

EUC_KR

ksc5601, euc-kr, euckr, ks_c_5601-1987, ksc5601-1987, ksc5601_1987, ksc_5601, 5601

EUC_TW

cns11643, euc-tw, euctw

ISO2022JP

jis, iso-2022-jp, csiso2022jp, jis_encoding, csjisencoding

ISO8859_1

8859_1, iso_8859-1:1978, iso-ir-100, iso_8859-1, iso-8859-1, iso8859-1, latin1, l1, ibm819, ibm-819, cp819, 819, csisolatin1

ISO8859_15_FDIS

8859_15, iso-8859-15, iso_8859-15, iso8859-15, ibm923, ibm-923, cp923, 923, latin0, latin9, csisolatin0, csisolatin9

ISO8859_2

8859_2, iso_8859-2:1987, iso-ir-101, iso_8859-2, iso-8859-2, iso8859-2, latin2, l2, ibm912, ibm-912, cp912, 912, csisolatin2

ISO8859_3

8859_3, iso_8859-3:1988, iso-ir-109, iso_8859-3, iso-8859-3, iso8859-3, latin3, l3, ibm913, ibm-913, cp913, 913, csisolatin3

ISO8859_4

8859_4, iso_8859-4:1988, iso-ir-110, iso_8859-4, iso-8859-4, iso8859-4, latin4, l4, ibm914, ibm-914, cp914, 914, csisolatin4

ISO8859_5

8859_5, iso_8859-5:1988, iso-ir-144, iso_8859-5, iso-8859-5,iso8859-5, cyrillic, csisolatincyrillic, ibm915, ibm-915, cp915, 915

ISO8859_6

8859_6, iso_8859-6:1987, iso-ir-127, iso_8859-6, iso-8859-6, iso8859-6, ecma-114, asmo-708, arabic, csisolatinarabic, ibm1089, ibm-1089, cp1089, 1089

ISO8859_7

8859_7, iso_8859-7:1987, iso-ir-126, iso_8859-7, iso-8859-7, iso8859-7, elot_928, ecma-118, greek, greek8, csisolatingreek, ibm813, ibm-813, cp813, 813

ISO8859_8

8859_8, iso_8859-8:1988, iso-ir-138, iso_8859-8, iso-8859-8, iso8859-8, hebrew, csisolatinhebrew, ibm916, ibm-916, cp916, 916

ISO8859_9

8859_9, iso-ir-148, iso_8859-9, iso-8859-9, iso8859-9, latin5, l5, ibm920, ibm-920, cp920, 920, csisolatin5

ISO8859_13

8859_13, iso_8859-13, iso-8859-13, iso8859-13,

JISAutoDetect

jis auto detect

Johab

ksc5601-1992, ksc5601_1992, ms1361

KOI8_R

koi8-r, koi8, cskoi8r

MS874

windows-874

MS932

shift_jis, ms_kanji, csshiftjis, windows-31j, cswindows31j, x-sjis

MS949

windows-949

SJIS

shift_jis, pck

TIS620

tis620.2533

UTF8

utf-8, unicode-1-1-utf-8

UTF16

utf-16

Unicode

unicode

UnicodeBig

unicode-1-1, iso-10646-ucs-2, utf-16be, x-utf-16be

UnicodeLittle

utf-16le, x-utf-16le