Character Set for a Column in a Table
From InterBase
Go Up to Specifying Character Sets
Character sets for individual columns in a table can be specified as part of the column’s CHAR
or VARCHAR
data type definition. When a character set is defined at the column level, it overrides the default character set declared for the database. For example, the following isql
statements create a database with a default character set of ISO8859_1, then create a table where two column definitions include a different character set specification:
CREATE DATABASE 'europe.ib' DEFAULT CHARACTER SET ISO8859_1;
CREATE TABLE RUS_NAME(
LNAME VARCHAR(30) NOT NULL CHARACTER SET CYRL,
FNAME VARCHAR(20) NOT NULL CHARACTER SET CYRL,
);
For the complete syntax of CREATE TABLE
, see CREATE TABLE.