Figure 10-3 shows the directory structure for the Western European character sets that come with Adaptive Server. There is a separate subdirectory for each character set in the charsets directory. Within the subdirectory for each character set (for example, cp850) are the character set and sort order definition files and terminal-specific files.
If you load additional character sets, they also appear in the charsets directory:
Figure 10-3: Structure of the charsets directory
The following global variables contain information about character sets:
@@char_convert – contains 0 if character set conversion is not in effect. Contains 1 if character set conversion is in effect.
@@client_csname – the client’s character set name. Set to NULL if client character set has never been initialized; otherwise, contains the name of the character set for the connection.
@@client_csid – the client’s character set ID. Set to -1 if client character set has never been initialized; otherwise, contains the client character set ID from syscharsets for the connection.
@@client_csexpansion – returns the expansion factor used when converting from server's character set to client's character set.
@@maxcharlen – the maximum length, in bytes, of a character in the Adaptive Server default character set.
@@ncharsize – the maximum length, in bytes, of a character set in the current server default character set.
@@unicharsize – equals 2.
