Purpose
Specifies a character set to be used for translation of data to and from the Teradata Database at program execution.
Invocation
Executable.
Embedded SQL only.
Syntax
SET CHARSET { character_set_name | :character_set_name_variable }
- character_set_name
- The character set to be used in translating data between the client and the Teradata Database.
- :character_set_name_variable
- A host variable that contains the name of the character set to be used in translating data between the client and the Teradata Database.
ANSI Compliance
SET CHARSET is a Teradata extension to the ANSI/ISO SQL:2011 standard.
Authorization
None.
Usage Notes
SET CHARSET overrides the default character set used for communication between the application and the Teradata Database at runtime.
Rules
- Whether specified as character_set_name or as :character_set_name_variable, the character set name must be a valid character set identifier.
- If used to identify the character set name rather than the character set code, character_set_name must be enclosed in apostrophes, based on the APOST/QUOTE preprocessor option setting.
- If used to identify the character set name, :character_set_name_variable must follow the rules for SQL strings for the client language.
- If used to identify the character set code, :character_set_name_variable must be defined as a small integer host variable.
- Specification of the SET CHARSET statement does not affect preprocessor processing, just the data sent and retrieved from the Teradata Database at execution time.
Related Topics
For information on UTF-8 and UTF-16 character sets and specific UTF-8 and UFT-16 programming considerations or about :character_set_name_variable, see Teradata® Preprocessor2 for Embedded SQL Programmer Guide, B035-2446.