Re: How to display Unicode in SQL

Thanks, that did it. But a note in the manual seems odd:

Vern

I have never tried it, but could you wrap the column in a function like
CHAR()?

Mark

midrange-l-bounces@xxxxxxxxxxxx wrote on 09/15/2004 12:51:31 PM:

> The discussion on Unicode coincides with a little problem I'm having.
I've
> looked a little in the SQL Reference and other SQL manuals, but I've
found
> nothing on this.
>
> I am working with an IBM output file for performance data. One of the
> columns is Unicode (UCS-2, I assume) - CCSID 13488. The others are
numeric
> or character or some sort. A SELECT in STRSQL shows the Unicode column
in
> the usual EBCDIC fashion - accented characters with intervening blanks
> (actually x'00' bytes but get converted to displayable blanks).
>
> The file is QAPMJOBWTD - found from V5R2 onward, I believe.
>
> Thanks
> Vern

_____________________________________________________________________________
Scanned for SoftLanding Systems, Inc. by IBM Email Security Management Services powered by MessageLabs.
_____________________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.