Re: CPYTOIMPF and accented characters

Its a customer software developed 100s of years ago :) This software is
used by 150+ countries and they all have same database structure.. I won't
be able to make any changes at database level.. but its nice to get good
understanding of CCSID with your help!

Thanks again for help and explanation..

On Thu, Nov 3, 2016 at 8:31 AM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 11/2/2016 6:37 PM, Mohammad Tanveer wrote:

ok here it is... my data is in a table with fields defined with CCSID 37

My JOB CCSID = 37

That's the issue. What is happening is that someone is storing a
Swedish character in an English column. Naturally, this is going to be
a problem.

In CCSID(37):
A-ring is x'67'
$ is x'5B'
AE is x'9E'

ftp://ftp.software.ibm.com/software/globalization/gcoc/
attachments/CP00037.pdf

In CCSID(278):
A-ring is x'5B'
$ is x'67'
AE is x'9E'

ftp://ftp.software.ibm.com/software/globalization/gcoc/
attachments/CP00278.pdf


If the intent is to store Swedish characters, the column should almost
certainly be tagged as CCSID(278). Because as the situation now stands,
the users are lying to the system - they are storing Swedish in an
English column, which will mess up translations.


--
--buck

Visit wiki.midrange.com and register for an account. Edit a page that
helps you, and because it's public, you'll help someone else, too!

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.