Skip to main content Skip to complementary content

Database specific considerations

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!