To ensure multibyte or foreign characters are saved properly for string column types, the Agent creates column types that can store unicode string data such as NVARCHAR (MySQL, MS SQL Server, etc). You can use other data types other than N type fields by editing the databases.xml.


Prerequisites


(warning)  Request the databases.xml file for your DataSync Agent by contacting Perspectium Support.


Procedure

To change the data types in the databases.xml, complete the following steps:


Navigate to database_type configuration

In the databases.xml file, open the file in a text-editing application and locate the configurations for your database type <database_type><your database></database_type>.

Change data type

Change the data types to your configuration inside the <mapping> tag.

For example, if you have an Oracle database and you want to use CLOB instead of NCLOB, change

<mapping sn_type="2011" db_type="2011">NCLOB</mapping> 

to

<mapping sn_type="2011" db_type="2011">CLOB</mapping>

Save your changes

Save the databases.xml file and put the file within the conf directory that was created upon installation of your DataSync Agent.