Hp Neoview Release 2.5 Software Instrukcja Użytkownika Pobierz pdf (Strona 65)

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 <ucs2-view> where <column-name> = TRANSLATE('ISO_abc' USING ISO88592ToUCS2);

The next example translates a hexadecimal literal to UCS2:

Select * from <ucs2-view> where <column-name> = 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 65

1 2 ... 60 61 62 63 64 65 66 67 68 69 70 ... 141 142

Brak uwag

Hp Neoview Release 2.5 Software Instrukcja Użytkownika Strona 65