Language and character set information in global variables

Table 14-7 lists the global variables that contain information about languages and character sets. For more information on languages and character sets, see the System Administration Guide.

Table 14-7: Global variables for language and character sets

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_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.

@@char_convert

Contains 0 if character set conversion is not in effect. Contains 1 if character set conversion is in effect.