Neoview SQL Reference Manual (R2.3)

TRANSLATE Function
The TRANSLATE function translates a character string from a source character set to a target
character set.
TRANSLATE(character-value-expression USING translation-name)
character-value-expression
is a character string.
translation-name
is one of these translation names:
CommentsTarget Character SetSource Character SetTranslation Name
No data loss is possible.UCS2ISO8859XISO8859XToUCS2 (X in 1)
No data loss is possible.
Neoview SQL will display
error 8413 if it encounters
a Unicode character that
cannot be converted to the
target character set.
ISO8859XUCS2UCS2ToISO8859X (X in 1)
translation name identifies the translation, source and target character set. When you
translate to the UCS2 character set no data loss is possible. However, when Neoview SQL
translates a character-value-expression from UCS2, certain characters encoded in
UTF16 cannot be converted to the target character set. Neoview SQL displays an error in this
case.
Neoview SQL returns a variable-length character string with character repertoire equal to
the character repertoire of the target character set of the translation and the maximum length
equal to the fix length or maximum variable length of the source
character-value-expression.
If you enter an illegal translation-name, Neoview SQL returns an error.
If the character set for character-value-expression is different from the source character
set as specified in the translation-name, Neoview SQL returns an error.
428 SQL Functions and Expressions