Re: How to display Unicode in SQL -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.