Database specific considerations - 6.3

Troubleshooting for MDM SQL Storage

EnrichVersion
6.3
task
Installation and Upgrade
EnrichPlatform
Talend MDM Server
Bear in mind the following when you need to handle data types and SQL statements with different databases.

Oracle

For the xsd:decimal element, trailing zeros are removed. For example, if you write a value "130000.00", reading it later returns "130000".

SQL Server

For xsd:byte and xsd:unsignedByte, SQL Server uses unsigned bytes. If Microsoft JDBC driver is used, searching for "entity with field > -50" is automatically converted into "entity with field > 50" since the minus character will be removed.