Character Columns

You can use the CHARACTER SET clause to specify the character set for the CHAR, VARCHAR and BLOB (text subtype) types.If the character set is not specified, the default character set of the database — at time of the creation of the column — will be used.

If the database has no default character set, the NONE character set is applied.Data in any encoding can be added to such a column, but it is not possible to add this data to a column with a different encoding.No transliteration is performed between the source and destination encodings, which may result in errors.

The optional COLLATE clause allows you to specify the collation for character data types, including BLOB SUB_TYPE TEXT.If no collation is specified, the default collation for the specified character set — at time of the creation of the column — is applied.

The CREATE TABLE statement can be executed by:

The user executing the CREATE TABLE statement becomes the owner of the table.