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