Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software

char, nchar, varchar and nvarchar

char[(n)]

Fixed-length character data in single-byte character sets with length of n characters. n must be a value from 1 through 255. Storage size is n bytes.

nchar[(n)]

Fixed-length character data in multibyte character sets with length of n characters. n must be a value from 1 through 255. Storage size is n*@@ncharsize bytes.

varchar[(n)]

Variable-length character data in single-byte character sets with length of n characters. n must be a value from 1 through 255. Storage size is the actual length of the data entered, not n bytes.

nvarchar[(n)]

Variable-length character data in multibyte character sets with length of n characters. n must be a value from 1 through 255. Storage size, in bytes, is the actual number of characters entered * @@ncharsize.

Remarks

When n is not specified in a data definition, the default length is 1.