SET CHARSET Usage Notes - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
  • SET CHARSET overrides the default character set used for communication between the application and the database at runtime.
  • 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, only the data sent and retrieved from the database at execution time.