Progress
Internationalization Guide
The Maximum Number Of Bytes Required By Fields Of Type CHAR and VARCHAR
In Progress SQL-92, when you create a field of type CHAR or VARCHAR, the maximum number of bytes required depends on whether the code page is single-byte, double-byte, or triple-byte. For example, a CHAR(4) field requires a maximum of 4 bytes if the code page is single byte, a maximum of 8 bytes if the code page is double-byte, and a maximum of 12 bytes if the code page is triple-byte.
NOTE: If you define a field as CHAR(10000) and the code page is UTF–8, which is a triple byte, the field requires a maximum of 30,000 bytes of storage.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |