Skip to main content
๐Ÿ““ Tibero Online Manual Click here ๐Ÿ““

Search

Welcome to Tibero GTS!

DB LINK Character Set Error Resolution (2)

Document Type | Troubleshooting

Category | Interface/Integration

Document Number | TIITS016

 

Issue

When using DB link (Tibero to Oracle or Tibero to Gateway), an error message occurs and DML is not executed.
 

Applicable Environment: Tibero(MSWIN949) to ORACLE(UTF8)

insert into table select * from XXX@dbLink

> Error message: ERROR_DML_DIFF_CHARSET_NOT_PERMITTED(-8164) [ Unable to convert data due to character set mismatch.
 
 
 
 

Cause

This phenomenon occurs when the character sets of the DB link (Tibero to Oracle or Tibero to Gateway) are different.

 

 

Solutions

Change the settings to execute queries affected by character set even when the character sets are different.
  • Option 1. Apply _ALLOW_DIFF_CHARSET_INSTANCE=Y in the TIP file
  • Option 2. Apply alter system set _ALLOW_DIFF_CHARSET_INSTANCE=Y;
     
Note
Meaning of _ALLOW_DIFF_CHARSET_INSTANCE
Determines whether to execute queries affected by CHARSET when the character sets are different between TIBERO INSTANCES (Tibero to Tibero or Tibero to GateWay). (Default: N)

 

 

 

 

Related to