Re: How to display Unicode in SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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

Vern

At 12:01 PM 9/15/2004, you wrote:
> 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.