DatabaseCharacterSet
The database character set determines the character set in which data is stored.
Note:
You are required to specify the database character set at database creation time only. It cannot be altered after the database has been created. If you do not specify a value for this attribute when creating a database, TimesTen returns error message 12701.
Generally, your database character set should be chosen based on the data requirements. For example: Do you have data in Unicode or is your data in Japanese on UNIX and Linux systems (EUC
) or Windows (SJIS
)?
You should choose a connection character set that matches your terminal settings or data source. See ConnectionCharacterSet.
When the database and connection character sets differ, TimesTen performs the data conversion internally based on the connection character set. If the connection and database character sets are the same, TimesTen does not need to convert or interpret the data set. Best performance occurs when connection and database character sets match, since no conversion is required.
To use this attribute you must specify a supported character set. For a list of supported character set names, see Supported Character Sets below.
There are several things to consider when choosing a character set for your database. For a discussion about these considerations, see Choosing a Database Character Set in Oracle TimesTen In-Memory Database Operations Guide.
Required Privilege
Only the instance administrator can change the value of this attribute.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.Setting
Set DatabaseCharacterSet
name as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
Specify the preferred character set. |
Windows ODBC Data Source Administrator |
Not applicable |
Supported Character Sets
The following tables describe the character sets supported in TimesTen.
Asian Character Sets
Name | Description |
---|---|
|
|
|
The same as |
|
|
|
The same as |
|
|
|
Microsoft Windows Code Page 949 Korean |
|
Thai Industrial Standard 620-2533 - ASCII 8-bit |
|
Microsoft Windows Code Page 1258 8-bit Vietnamese |
|
|
|
|
|
|
|
|
|
Microsoft Windows Code Page 950 with Hong Kong Supplementary Character Set |
|
Microsoft Windows Code Page 950 Traditional Chinese |
European Character Sets
Name | Description |
---|---|
|
Latvian Standard |
|
ISO 8859-13 Baltic |
|
Microsoft Windows Code Page 1257 8-bit Baltic |
|
IBM-PC Code Page 775 8-bit Baltic |
|
ISO 8859-13 Celtic |
|
ISO 8859-5 Latin/Cyrillic |
|
RELCOM Internet Standard 8-bit Latin/Cyrillic |
|
KOI8 Ukrainian Cyrillic |
|
Microsoft Windows Code Page 1251 8-bit Latin/Cyrillic |
|
ISO 8859-2 East European |
|
ISO 8859-7 Latin/Greek |
|
Microsoft Windows Code Page 923 8-bit Estonian |
|
Microsoft Windows Code Page 1250 8-bit East European |
|
Microsoft Windows Code Page 1253 8-bit Latin/Greek |
|
IBM-PC Code Page 737 8-bit Greek/Latin |
|
IBM-PC Code Page 852 8-bit East European |
|
Microsoft Windows Code Page 921 8-bit Lithuanian |
|
ISO 8859-10 North European |
|
ISO 8859-4 North and North-East European |
|
IBM-PC Code Page 866 8-bit Latin/Cyrillic |
|
ISO 8859-3 South European |
|
ASCII 7-bit American |
|
IBM-PC Code Page 437 8-bit American |
|
ISO 8859-1 West European |
|
ISO 8859-15 West European |
|
Microsoft Windows Code Page 1252 8-bit West European |
|
IBM-PC Code Page 850 8-bit West European |
|
IBM-PC Code Page 858 8-bit West European |
Middle Eastern Character Sets
Name | Description |
---|---|
|
Arabic MS-DOS 720 Server 8-bit Latin/Arabic |
|
ASMO Extended 708 8-bit Latin/Arabic |
|
ISO 8859-6 Latin/Arabic |
|
Microsoft Windows Code Page 1256 8-Bit Latin/Arabic |
|
ISO 8859-9 Latin Azerbaijani |
|
ISO 8859-8 Latin/Hebrew |
|
Microsoft Windows Code Page 1255 8-bit Latin/Hebrew |
|
Microsoft Windows Code Page 1254 8-bit Turkish |
|
IBM-PC Code Page 857 8-bit Turkish |
|
ISO 8859-9 West European & Turkish |
Universal Character Sets
Name | Description |
---|---|
|
Unicode 4.0 UTF-16 Universal character set. This is the implicit TimesTen national character set. This character set cannot be specified as a value to the DatabaseCharacterSet or ConnectionCharacterSet attributes. |
|
Unicode 4.0 UTF-8 Universal character set |
|
Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant |