Save email address on DB2 Table

imagines · New User Joined: 10 Sep 2007 Posts: 18 Location: Italy

Hi
When I try to save an email address
the @ symbol is not save correctly. the symbol saved is this

enrico-sorichetti · Posted: Tue Oct 26, 2010 2:34 pm

look at the string in HEX,
if the hex value corresponds to the @ char, then check the 3270 emulator character mappings

or simpler...
open a member under ispf and check that all the chars You type are displayed properly !

imagines · New User Joined: 10 Sep 2007 Posts: 18 Location: Italy

HEx value is x'B5' . If I open a member in ispf i write @ and i see @.
when I insert this value i a Db2 table through QMF or Cobol program i write @ and then after save i see a bad symbol

imagines · New User Joined: 10 Sep 2007 Posts: 18 Location: Italy

I THINK that the proble is EBCDIC / CCSID encoding characters

dbzTHEdinosauer · Posted: Tue Oct 26, 2010 3:59 pm

you should view the db2 column in hex using file-aid or some other db2 tool
or
simply select the column with the hex function

to determine what value is actually stored.

and as was suggested, you need to verify your code page settings.