Global variables affected by set options  Global variables for monitoring system activity

Chapter 14: Using Batches and Control-of-Flow Language

Language and character set information in global variables

Table 14-8 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-8: 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_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.





Copyright © 2005. Sybase Inc. All rights reserved. Global variables for monitoring system activity

View this book as PDF