Cracking & #65279; incompatible DB2 code page, simple!

The following articles mainly describe the problem of compatibility with the DB2 coding page. This article first describes the problem after the system returns the DB2 connect to db_name command, the following is a detailed description of the main content of the article. I hope you will have a better understanding of it after browsing.

For example:

When the command: db2 connect to db_name is issued, the system returns

 
 

  
  
SQL0332N There is no available conversion for the source code page "819" to the target code page "1386". Reason Code "1". SQLSTATE=57017 
 
 

DB2 requires that the source code page and the target code page be compatible with each other. In the preceding example, the database connection fails because the source code page is 819 incompatible with the target code page 1386.

The solution is as follows:

On the machine that fails to issue the db2 connect command, execute the following command in the DB2 command window and re-connect:

 
 

  
  
-> 
  
  
db2set db2codepage=1386 –I instance_name  
  
  
db2 terminate   
 
 

The above content is an introduction to the incompatibility problem of the DB2 coding page. I hope you will get some benefits.

The above content is a description of the incompatibility problem with the DB2 coding page, hoping to help you in this regard.