HP Neoview Release 2.5 Software User Manual

Page 65

Text mode
Original mode

The TRANSLATE function is another option for specifying a UCS2 literal. For example, the
following query uses the TRANSLATE function to translate an ISO8859-1 character string to
UCS2:

Select * from where = TRANSLATE('ISO_abc' USING ISO88592ToUCS2);

The next example translates a hexadecimal literal to UCS2:

Select * from where = TRANSLATE(X'48 45 58 5F 61 62 63' USING ISO88592ToUCS2);

For a much more extensive discussion of character sets on the Neoview platform, see the Neoview
Character Sets Administrator's Guide.

Retrieving UCS2 Columns From a Workstation Configured for ISO8859-1