× 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.



On 11/2/2016 3:19 PM, Mohammad Tanveer wrote:
It looks like when I entered the data as per your example it took it as
ASCII character code that is why it appeared correctly.

I copied the data from my database which stored the data as Danish
character set then translation is not happening correctly.. looks like my
problem still exists

Stored how?
DSPFFD and tell us what the CCSID of the column is.

You can see Record#1 was copied using the values from Danish CCSID 278 and
#2 was entered manually using the SQL

STRSQL(US 037 Mode)
RRN ( A ) CHAR_COLUMN
1 M$GEVEJ 44 (entered using den/swe character set)
2 MÅGEVEJ 44 (ASCII input)
3 KÆRBØLVEJ 52

Entered how?
By a TN5250 job last year with a CCSID of 65535?
By DBU just now with a job CCSID of 65535?
By DBU just now with a job CCSID of 278? 37?

I'm trying to understand the situation you face there, but I don't have
enough information yet to re-create the problem here. I gave an example
of your data and your CCSIDs and it works, so either your people are
doing something different or there's a PTF you need that I have. I'm on
TR4 (WRKPTFGRP, SF99717).

For one more added data point, here is DSPPFM DANISH

KÆRBØLVEJ 52
D9DC8DECD4FF444444444444444444
2E9203551052000000000000000000

M$GEVEJ 44
D5CCECD4FF44444444444444444444
4B7555104400000000000000000000


Here is DBU DANISH

KÆRBØLVEJ 52
D9DC8DECD4FF444444444444444444
2E9203551052000000000000000000
MÅGEVEJ 44
D6CCECD4FF44444444444444444444
477555104400000000000000000000


Here is SELECT HEX(CHAR_COLUMN) FROM DANISH

D29ED9C280D3E5C5D140F5F2404040404040404040404040404040404040
D45BC7C5E5C5D140F4F44040404040404040404040404040404040404040

All on a green screen with job CCSID(37). What does your system show?

One more thing. CCSID 278 has assigned 'A-ring' to x'5B'
ftp://ftp.software.ibm.com/software/globalization/gcoc/attachments/CP00278.pdf
So DSPPFM is correct to show me x'5B' as the raw data.

I found that PDF from here:
https://www-01.ibm.com/software/globalization/cp/cp_cpgid.html



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.