If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > CODEPAGE problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-07-05, 09:14
M_RAS M_RAS is offline
Registered User
 
Join Date: Sep 2003
Location: canada
Posts: 230
CODEPAGE problem

I am working with db2 v5.2 and aix 4.3.3

recently we found out database can not handle franch words in just one of out database in this instance (two other database are fine) after some investigation I found that code page in db cfg is 850 and in syscat.packages table is 819 (other two databases both values are 850) could you please someone tell me How it comes? is it the root cause of my problem? and how can I fix that.
thank you in advace for your help.
Reply With Quote
  #2 (permalink)  
Old 02-15-05, 15:30
ljrong ljrong is offline
Registered User
 
Join Date: Jan 2002
Location: USA
Posts: 53
At /export/home/db2inst1/sqllib/cfg directory, there is a file named db2cli.ini

At beginning

Add following
[COMMON]
disableunicode=1


WTH
Reply With Quote
  #3 (permalink)  
Old 02-15-05, 15:45
M_RAS M_RAS is offline
Registered User
 
Join Date: Sep 2003
Location: canada
Posts: 230
Quote:
Originally Posted by ljrong
At /export/home/db2inst1/sqllib/cfg directory, there is a file named db2cli.ini

At beginning

Add following
[COMMON]
disableunicode=1


WTH
Thank you for your help,
A question: after changing should I compile the application or bind/rebind the packages?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On