Hp Neoview Release 2.5 Software Manuel d'utilisateur télécharger pdf (Page 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

Pas de commentaire

Hp Neoview Release 2.5 Software Manuel d'utilisateur Page 65