Dropping all Apostrophe's

sivasaras · New User Joined: 29 Sep 2007 Posts: 93 Location: chenna/i-

Hi,

My program is having both jave and maninfame.

in front end they are entering the valuse with apostrophe’s like

hai thé à test spécial

while storing it is showing as with ? marks in the screen, it is dropping all apostrophe's like below in the fron end java screen

hai th? a? test sp?cial

i am using a stored procedure.

plz guide me how to insert the same value in the db2 and display in the acreen correctly.

GuyC · Posted: Fri Nov 22, 2013 7:54 pm

Talk to an experienced developer/system engineer at your site.
Multiple codepages/unicode-ebcdic-ascii is a bit much to explain to someone who has programs in "jave and maninfame" (sic)

enrico-sorichetti · Posted: Fri Nov 22, 2013 7:57 pm

in IT using the proper terminology is essential for good communication

Robert Sample · Posted: Fri Nov 22, 2013 8:01 pm

This is a code page issue -- the mainframe is storing the data using a code page that does not support the special characters being used in the front end. You need to identify which code page the front end uses, and ensure that DB2 stores your data using that code page.

Also, terminology is critial in IT where similar terms may mean very different things. The data does not have apostrophes (which are separate characters), the characters have diacritic marks; depending upon the language there are several different diacritic marks (tilde, circumflex, acute, grave for example) but they are not considered separate from the character.