Re: CPYTOIMPF and accented characters

[Buck Calabro <kc2hiz@xxxxxxxxx>]

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