Assigning Default Client Character Set for a Session | Teradata Vantage - 17.10 - Assigning the Default Client Character Set for a Session - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

You can control the session parameter that defines the character set to be used for external representation from within the client application submitting the request. Specifying an alternate character set overrides the default client character set for a session.

For example, in BTEQ you can use the SESSION CHARSET command to set the character set for the current session:

.SET SESSION CHARSET 'ascii'

Make sure the character set you use (for example, 'ascii') exactly matches the name of a valid, enabled client character set.

For further information on how to use a session character set, see the users guide for the particular application.