Table 15-8 lists the global variables that contain information about languages and character sets. See Chapter 9, “Configuring Character Sets, Sort Orders, and Languages,” in the System Administration Guide: Volume 1.
Global variable |
Description |
|---|---|
@@char_convert |
Contains 0 if character set conversion is not in effect. Contains 1 if character set conversion is in effect. |
@@client_csid |
Contains client’s character set ID. Set to -1 if the client character set has never been initialized; otherwise, it contains the most recently used client character set’s id from syscharsets. |
@@client_csexpansion |
Returns the expansion factor used when converting from the server character set to the client character set. For example, if it contains a value of 2, a character in the server character set can take up to twice the number of bytes after translation to the client character set. |
@@client_csname |
Contains client’s character set name. Set to NULL if the client character set has never been initialized; otherwise, it contains the name of the most recently used character set. |
@@langid |
Defines the local language ID of the language currently in use, as specified in syslanguages.langid. |
@@language |
Defines the name of the language currently in use, as specified in syslanguages.name. |
@@maxcharlen |
Contains the maximum length, in bytes, of multibyte characters in the default character set. |
@@ncharsize |
Contains the average length, in bytes, of a national character. |
