SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
9-191
TRANSLATE Function
translation-name
is one of these translation names:
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 NonStop SQL/MX translates a character-value-expression from
UCS2, certain characters encoded in UTF16 cannot be converted to the target
character set. NonStop SQL/MX displays an error in this case.
NonStop SQL/MX 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, NonStop SQL/MX returns an error.
If the character set for character-value-expression is different from the
source character set as specified in the translation-name, NonStop SQL/MX
returns an error.
Translation Name Source
Character Set
Target
Character Set
Comments
ISO8859XToUCS2
(X in 1)
ISO8859X UCS2 No data loss is possible.
UCS2ToISO8859X
(X in 1)
UCS2 ISO8859X
No data loss is possible.
NonStop SQL/MX will
display error 8413 if it
encounters a Unicode
character that cannot be
converted to the target
character set.
KANJITOISO88591 KANJI ISO88591
Convert a KANJI source
to a multibyte ISO88591
target. Every character is
copied as is. No check on
the source data. No data
loss is possible.
KSC5601TOISO88591 KSC5601 ISO88591 Convert a KSC5601
source to a multibyte
ISO88591 target. Every
character is copied as is.
No check on the source
data. No data loss is
possible.