Character set / conversion

[Pikkunero]

I'm having trouble with character sets and character conversion. Database is DB2 ver. 5.2 on an AS/400 system.

I'm coding an application with Delphi 5 and it will have additional tools on the web.

So. I need to be able to show both western european character set and cyrillic character set on my delphi application. When using the application i can store cyrillic characters to DB2 though without my app they don't make any sence. I mean that my application handles the conversion somehow... So if i write ???? to my app, it shows like this in the DB2: ÔÈÈÔ...

Well... this i can handle. I doesn't bother me so much. As long as it works. But the real problem is that when a client tries to add new data from a web page to DB2 using cyrillic character set then for some reason the characters go to the DB as ASCII numbers.

So when an address field for example is 35 chars long, then it will only accept 5 ASCII characters like this: (УЛОА&#1054.

So. Is the problem in the AS/400 + DB2 environment or someplace else. I'm thinking that this could relate to the database's CCSIDs.

 

[leveyp]

If you are accessing DB2 files (tables) check out the CCSIS
on the table:
From an AS/400 command line type DSPFD OURLIBRARY/YOURFILE and Find CCSID.

Check what character translation is specified in you ODBC or other datasource.