Handling "@" character in different code pages in mainframes.
Handling "@" character in different code pages in mainframes.
Hi,
One of our other teams where I'm not directly involved has got a problem with the "@" character using in then email-IDs.
I might get murky in my explanation however please bear with me and I'll to add on as and when required.
Three things involved in the problem - mainframe, Rumba emulator and Database DB2. DB2 has got interface with green screen and Web (Java) as well. DB2 resides on mainframe and is a centralized database, that is this data can be fetched from many geographical locations. When data is entered using the web-interface and an email is entered with "@" and fetched back in ENEA region it comes out as "§" (section sign) which is not acceptable, obviously.
I understand that this can be worked upon by the correct code pages but what to if the data is being fetched from a centralized database?
One of our other teams where I'm not directly involved has got a problem with the "@" character using in then email-IDs.
I might get murky in my explanation however please bear with me and I'll to add on as and when required.
Three things involved in the problem - mainframe, Rumba emulator and Database DB2. DB2 has got interface with green screen and Web (Java) as well. DB2 resides on mainframe and is a centralized database, that is this data can be fetched from many geographical locations. When data is entered using the web-interface and an email is entered with "@" and fetched back in ENEA region it comes out as "§" (section sign) which is not acceptable, obviously.
I understand that this can be worked upon by the correct code pages but what to if the data is being fetched from a centralized database?
- prino
- Registered Member
- Posts: 68
- Joined: Sun Jun 01, 2014 4:15 am
- Location: Vilnius, Lithuania
- Contact:
Re: Handling "@" character in different code pages in mainframes.
I'm pretty sure the "@" sign is EBCDIC code-page invariant, so it should have been stored as "@" in DB2! And it's 0x40 in both ASCII and UTF-8, so there are also no conversion problems!
Check the Rumba codepage for the ENEA region?
Check the Rumba codepage for the ENEA region?
Re: Handling "@" character in different code pages in mainframes.
Thanks prino.
Sorry it's EMEA.
In Germany, the point of entry in Rumba, code page is CP273, which encodes the @ symbol in the email address as X’B5’ (and the § “section sign” as X’7C’). So to answer your question for EMEA it's CP273.
On further investigation, I came to know that - "as a general rule of thumb, for green screens, if the locale that authors the data also retrieves it there is no issue. But as data is shared across geographic locales within the team can create issues. And data that moves across platforms may create issues as well because of translations to ASCII encoding as well as UNICODE."
I'm somewhat not convinced with this argument as I've worked with multi geographical locations in other companies too and never observed such a problem. May be there is more to it.
Sorry it's EMEA.
In Germany, the point of entry in Rumba, code page is CP273, which encodes the @ symbol in the email address as X’B5’ (and the § “section sign” as X’7C’). So to answer your question for EMEA it's CP273.
On further investigation, I came to know that - "as a general rule of thumb, for green screens, if the locale that authors the data also retrieves it there is no issue. But as data is shared across geographic locales within the team can create issues. And data that moves across platforms may create issues as well because of translations to ASCII encoding as well as UNICODE."
I'm somewhat not convinced with this argument as I've worked with multi geographical locations in other companies too and never observed such a problem. May be there is more to it.
- Robert Sample
- Global Moderator
- Posts: 1896
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Handling "@" character in different code pages in mainframes.
I suspect something is not using the correct code page. EBCDIC 037 has X'B5' as the section symbol and X'7C' as the @ sign. EBCDIC 273 has X'B5' as the @ sign and X'7C' as the section symbol.
Re: Handling "@" character in different code pages in mainframes.
Looks like that's the reason but how do I identify that? That's the question.
-
- Registered Member
- Posts: 24
- Joined: Thu Nov 21, 2013 3:25 pm
Re: Handling "@" character in different code pages in mainframes.
If the data is stored in DB2, will it not just show exactly the way it has been stored. So that means sign "§" was stored incorrectly itself.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute