Re: CPYTOIMPF and accented characters

[Mohammad Tanveer <surgum@xxxxxxxxx>]

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.