Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HTML
<style>
.release-box {
	height: 30px; 
	width: 100px; 
	padding-top: 8px;
	text-align: center; 
	border-radius: 5px; 
	font-weight: bold; 
	background-color: #d4af37#0ACA8B;  
	border-color: #FCE28A;
}

.release-box:hover {
  	cursor: hand;
    cursor: pointer;
    opacity: .9; 
}
</style>
<meta name="robots" content="noindex">

<div class="release-box">
<a href="https://docs.perspectium.com/display/goldfluorineplus" style="text-decoration: none; color: #FFFFFF; display: block;">
GoldFluorine+
</a>
</div>



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:


UI Steps


UI Step

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


UI Step

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

Code Block
languagexml
themeEclipse
<mapping sn_type="2011" db_type="2011">NCLOB</mapping> 

to

Code Block
languagexml
themeEclipse
<mapping sn_type="2011" db_type="2011">CLOB</mapping>



UI Step

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.




Similar topics


Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
cqllabel = "data-sync" and space = currentSpace()

Contact Perspectium Support


US: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com