The Unicode datatypes unichar, univarchar,
and unitext have the same attributes as their char, varchar,
and text equivalents. See “Unicode datatypes”.
char(n) – any combination of up to 32,768 single-byte letters, symbols, and numbers. Specify the maximum size of the string with n. A char value can contain 0 characters, but n must be between 1 and 32,768. A multibyte string cannot exceed 32,768 bytes.
varchar(n) – any combination of up to 32,768 single-byte letters, symbols, and numbers. Specify the maximum size of the string with n. A varchar value can contain 0 characters if it is defined to allow null values, but n must be between 1 and 32,768. A multibyte string cannot exceed 32,768 bytes.
The difference between char and varchar data is the way the values are stored in Adaptive Server databases. Replication Server treats them as equivalent types, but maintains the distinction so that the storage method is the same in primary and replicate databases.
text – variable-length character columns up to 2,147,483,647 bytes in length. Replication Server does not support datatype conversion of text data. This means if your replication definition declares a column as text, the primary table’s columns must be text.
