Page Comparison

Dbvisit Replicate relies on the target database client settings for handling of NLS issues. For an Oracle target database, set the NLS_LANG environment variable to "AMERICAN_AMERICA.source_db_charset". The AMERICAN_AMERICA part ensures unified number and date formats and specifying the source database charset ensures that the client libraries handle any non-ASCII characters properlydoes not rely on any NLS variables to function properly.

It does not depend on any NLS setting in the user's environment. Rather, it overwrites NLS_LANG at the session level and so should not depend on any implicit conversion, meaning that it is not affected by any other environmental settings.

The value of APPLY.NLS_LANG AMERICAN_AMERICA.AL32UTF8  is used to set the environment variables.

Dbvisit Replicate uses APPLY.NCHARSET to understand what NCHARSET the source database is using, either UTF-8 or UTF-16.  Dbvisit Replicate will then convert the data to match the target NCHARSET.

With the non Oracle database (MySQL and MSSQL),  the connections are set to  use Unicode only (UTF-8 for MySQL and UTF-16 for MSSQL) - and then the data is converted according to NCHARSET to the format expected by the target db connection.

Replicating data between environments having different character set can be tricky sometimes, we have to make sure the columns having values other than the default character values( For example columns having Chinese characters) are handled properly. Conflicts will occur during these scenarios .

The solution for the problem is specifying datatype using NCHAR or NVARCHAR , we can also use length using "CHAR(100 CHAR)" . It says it should fit 100 characters, not 100 bytes. This should avoid any issues with character sets.