Versions Compared

Old Version 2

changes.mady.by.user user-1bc08

Saved on

compared with

New Version 3

changes.mady.by.user user-1bc08

Saved on

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;  
	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/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</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 another data types other than N type fields by editing the databases.xml.

Prerequisites


Prerequisite

(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

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

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


UI Step

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