Skip to content

Oracle NLS_CHARACTERSET All Available List

  • by

To retrieve all available NLS_CHARACTERSET in Oracle, we execute the following query to get the list.

SQL> select value "NLS_CHARACTERSET" from v$nls_valid_values where parameter = 'CHARACTERSET' AND isdeprecated = 'FALSE' order by 1;
Oracle All Available NLS_CHARACTERSET
NLS_CHARACTERSET
AL16UTF16
AL32UTF8
AR8ADOS710
AR8ADOS720
AR8APTEC715
AR8ARABICMAC
AR8ARABICMACS
AR8ASMO8X
AR8EBCDIC420S
AR8EBCDICX
AR8ISO8859P6
AR8MSWIN1256
AR8MUSSAD768
AR8NAFITHA711
AR8NAFITHA721
AR8SAKHR706
AR8SAKHR707
AZ8ISO8859P9E
BG8MSWIN
BG8PC437S
BLT8CP921
BLT8EBCDIC1112
BLT8EBCDIC1112S
BLT8ISO8859P13
BLT8MSWIN1257
BLT8PC775
BN8BSCII
CDN8PC863
CE8BS2000
CEL8ISO8859P14
CH7DEC
CL8BS2000
CL8EBCDIC1025
CL8EBCDIC1025C
CL8EBCDIC1025R
CL8EBCDIC1025S
CL8EBCDIC1025X
CL8EBCDIC1158
CL8EBCDIC1158R
CL8ISO8859P5
CL8ISOIR111
CL8KOI8R
CL8KOI8U
CL8MACCYRILLIC
CL8MACCYRILLICS
CL8MSWIN1251
D7DEC
D7SIEMENS9780X
D8BS2000
D8EBCDIC1141
D8EBCDIC273
DK7SIEMENS9780X
DK8BS2000
DK8EBCDIC1142
DK8EBCDIC277
E7DEC
E7SIEMENS9780X
E8BS2000
EE8BS2000
EE8EBCDIC870
EE8EBCDIC870C
EE8EBCDIC870S
EE8ISO8859P2
EE8MACCE
EE8MACCES
EE8MACCROATIAN
EE8MACCROATIANS
EE8MSWIN1250
EE8PC852
EEC8EUROASCI
EEC8EUROPA3
EL8DEC
EL8EBCDIC423R
EL8EBCDIC875
EL8EBCDIC875R
EL8GCOS7
EL8ISO8859P7
EL8MACGREEK
EL8MACGREEKS
EL8MSWIN1253
EL8PC437S
EL8PC737
EL8PC851
EL8PC869
ET8MSWIN923
F7DEC
F7SIEMENS9780X
F8BS2000
F8EBCDIC1147
F8EBCDIC297
HU8ABMOD
HU8CWI2
I7DEC
I7SIEMENS9780X
I8EBCDIC1144
I8EBCDIC280
IN8ISCII
IS8MACICELANDIC
IS8MACICELANDICS
IS8PC861
IW7IS960
IW8EBCDIC1086
IW8EBCDIC424
IW8EBCDIC424S
IW8ISO8859P8
IW8MACHEBREW
IW8MACHEBREWS
IW8MSWIN1255
IW8PC1507
JA16DBCS
JA16EBCDIC930
JA16EUC
JA16EUCTILDE
JA16EUCYEN
JA16MACSJIS
JA16SJIS
JA16SJISTILDE
JA16SJISYEN
JA16VMS
KO16DBCS
KO16KSC5601
KO16KSCCS
KO16MSWIN949
LA8ISO6937
LA8PASSPORT
LT8MSWIN921
LT8PC772
LT8PC774
LV8PC1117
LV8PC8LR
LV8RST104090
N7SIEMENS9780X
N8PC865
NDK7DEC
NE8ISO8859P10
NEE8ISO8859P4
NL7DEC
RU8BESTA
RU8PC855
RU8PC866
S7DEC
S7SIEMENS9780X
S8BS2000
S8EBCDIC1143
S8EBCDIC278
SE8ISO8859P3
SF7ASCII
SF7DEC
TH8MACTHAI
TH8MACTHAIS
TH8TISASCII
TH8TISEBCDIC
TH8TISEBCDICS
TR7DEC
TR8DEC
TR8EBCDIC1026
TR8EBCDIC1026S
TR8MACTURKISH
TR8MACTURKISHS
TR8MSWIN1254
TR8PC857
US7ASCII
US8BS2000
US8ICL
US8PC437
UTF8
UTFE
VN8MSWIN1258
VN8VN3
WE8BS2000
WE8BS2000E
WE8BS2000L5
WE8DEC
WE8DG
WE8EBCDIC1047
WE8EBCDIC1047E
WE8EBCDIC1140
WE8EBCDIC1140C
WE8EBCDIC1145
WE8EBCDIC1146
WE8EBCDIC1148
WE8EBCDIC1148C
WE8EBCDIC284
WE8EBCDIC285
WE8EBCDIC37
WE8EBCDIC37C
WE8EBCDIC500
WE8EBCDIC500C
WE8EBCDIC871
WE8EBCDIC924
WE8GCOS7
WE8HP
WE8ICL
WE8ISO8859P1
WE8ISO8859P15
WE8ISO8859P9
WE8ISOICLUK
WE8MACROMAN8
WE8MACROMAN8S
WE8MSWIN1252
WE8NCR4970
WE8NEXTSTEP
WE8PC850
WE8PC858
WE8PC860
WE8ROMAN8
YUG7ASCII
ZHS16CGB231280
ZHS16DBCS
ZHS16GBK
ZHS16MACCGB231280
ZHS32GB18030
ZHT16BIG5
ZHT16CCDC
ZHT16DBCS
ZHT16DBT
ZHT16HKSCS
ZHT16HKSCS31
ZHT16MSWIN950
ZHT32EUC
ZHT32SOPS
ZHT32TRIS

There're 222 NLS_CHARACTERSET in total.

Leave a Reply

Your email address will not be published.