ASE Limits
UTF-8 is a 1 to 3 byte, variable-width character set; therefore, in some instances,
you need more space to encode your data than you did with the national character
sets. Characters that were encoded as single-byte data may now be two or three
bytes, depending on the character set. The table below gives some general guidelines
as to how much larger your data will be. Refer to The Unicode Standard Version
for more information about specific characters in your script or language.
The following table shows the increase in space usuage by the new character
sets according to language:
Language
|
Native
character
set
|
UTF-8
character set |
% Increase |
English (ASCII
characters) |
1 byte |
1 byte |
No increase |
Japanese, Chinese,
Korean |
2 bytes |
3 bytes |
50% increase |
| Eastern and Western European languages |
1 byte |
Accented characters - 2 bytes |
Approximately 10 to 15% increase |
| Arabic, Cyrillic, Greek, Hebrew |
1 bytes |
2 bytes |
100% increase |
| Thai |
1 byte |
3 bytes |
200%increase |
Be aware of the following ASE limits as you design a new Unicode-enabled database:
Limit
Page
size (in bytes): |
2048
|
4096 |
8192 |
16384 |
| Max user-visible size of an APL data row |
1960 |
4008 |
8104 |
16296 |
| Max user-visible size of a DOL data row |
1958 |
4006 |
8102 |
16294 |
| Max user-visible size of a fixed-length column in an APL table |
1960 |
4008 |
8104 |
16296 |
| Max user-visible size of a fixed-length column in a DOL table |
1958 |
4006 |
8102 |
16294 |
| Max user-visible size of a variable-length column in an APL
table |
1948 |
3988 |
8068 |
16228 |
| Max user-visible size of a variable-length column in a DOL
table |
1954 |
4002 |
8098 |
16290 |
| Max user-visible index row-size |
600 |
1250 |
2600 |
5300 |
Workarounds
Use the following workarounds if your data exceeds current limits:
- If you exceed the row size limit, consider splitting the row across more
than one table. (This limit will be raised in a future release.)
- If you exceed the limits for column size, you can split the data across
multiple columns. (This limit will be raised in a future release.)
- If you exceed the index size limit, consider indexing your table on a different
column or moving one or more of the columns to another table. (An increase
in the limit on index size is being investigated for inclusion in a future
release.)
