Progress
Internationalization Guide
The Unit Of Length When Working With Character Strings
The string operators in Progress SQL-92 consider the unit of length to be the character count, not a byte count or a column count.
Consider the syntax of the Progress SQL-92 LEFT function:
LEFT evaluates character-string-expression and returns the leftmost length characters, whether single byte, double byte, or triple byte.
In the following expression, character-string-expression consists of a four characters: the first single byte. the second double byte, and the third and fourth single byte:
![]()
The preceding expression returns the following string, which consists of three characters, the second of which is double byte, for a total of four bytes:
![]()
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |