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
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.
