Switch to standard view 
  Sybase logo
 
 
 



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:



Back to Top
© Copyright 2010, Sybase Inc.