can anyone tell me default character set in teradata.
some people are telling ASCII, some people are telling LATIN.
Could u pls tell me which one is correct ?
they probably confuse server and client character sets :-)
LATIN or UNICODE are server character sets, while ASCII or UTF-8 or UTF-16 are client character sets.
There's a default server character set (modified by dbscontrol) used for the creation of new users, thus each user has a default which can be overwritten on a column level in a CREATE TABLE.
colname VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL
i want to make this col as nullable how to do this .can any one post the query.
In addition to the server character set that Dieter discussed, there is:
- a session character set that is used to encode and decode character data that is sent over the wire between the Teradata Database and the client interface software (CLI, the ODBC Driver, the JDBC Driver, or the .NET Data Provider)
- and a client character set corresponding to the character data encoding that the client application provides to the client interface software (the ODBC Driver, the JDBC Driver, or the .NET Data Provider).
The defaults for session character set and client character set are controlled by the client interface software.
Could you please post new questions as a new topic?
You need to use ALTER TABLE, the syntax is a bit weird as you actually modify the definition of an existing column:
ALTER TABLE tab ADD colname NULL