Content Comparison

...

• The SQL Mapper makes no attempt to marshal the values to the same type. The database is the final arbiter on how it handles an operation that involves unequal types, including throwing an error.

• The local evaluator makes a best effort to marshall types for comparison. E.g.

  • The arithmetic operators will try to convert each parameter to some form of number.

  • The boolean operators will try to convert each parameter to a Boolean.

  • The string-concatenation operator will try to convert each parameter to a string.

• Use the cast operator to explicitly marshal values to known types to avoid errors.

...

Basistypen

The primitive types are relatively standard.

Dates, times, and timespans

...