Unix Technical Forum

DB2 Encoding problem on MVS!!

This is a discussion on DB2 Encoding problem on MVS!! within the DB2 forums, part of the Database Server Software category; --> Hi all, I've a BIG problem on a J2EE application that uses DB2 database under MVS OS, I'm not ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 05:03 PM
Nabil BENMIRA
 
Posts: n/a
Default DB2 Encoding problem on MVS!!

Hi all,

I've a BIG problem on a J2EE application that uses DB2 database under
MVS OS, I'm not able
to read special characters(russian,...), but i can write them
from the database in UTF-8 format (even if i create the database using
the correct codepage).
to be more clear, the environnement is:

- IBM Websphere 4 with DB2 JDBC driver installed on MVS
- an UTF-8 DB2 database installed on MVS

PS : this application works if i use a database and a server installed
on windows!

if anyone have a suggestion or a little idea, please reply me (i'll be
very gratefull)

Nabil BENMIRA
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 05:03 PM
Anton Versteeg
 
Posts: n/a
Default Re: DB2 Encoding problem on MVS!!

Does setting the DB2CODEPAGE environement variable to 1208 (utf-8) do
any good?
If not there are some APAR fixes to be installed on MVS I believe.

Nabil BENMIRA wrote:

>Hi all,
>
>I've a BIG problem on a J2EE application that uses DB2 database under
>MVS OS, I'm not able
>to read special characters(russian,...), but i can write them
>from the database in UTF-8 format (even if i create the database using
>the correct codepage).
>to be more clear, the environnement is:
>
>- IBM Websphere 4 with DB2 JDBC driver installed on MVS
>- an UTF-8 DB2 database installed on MVS
>
>PS : this application works if i use a database and a server installed
>on windows!
>
>if anyone have a suggestion or a little idea, please reply me (i'll be
>very gratefull)
>
>Nabil BENMIRA
>
>


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:04 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com