Collation Order in Comparison
From InterBase
Go Up to Specifying Character Sets
When CHAR
or VARCHAR
values are compared in a WHERE
clause, it can be necessary to specify a collation order for the comparisons if the values being compared use different collation orders.
To specify the collation order to use for a value during a comparison, include a COLLATE
clause after the value. For example, in the following WHERE
clause fragment from an embedded application, the value to the left of the comparison operator is forced to be compared using a specific collation:
WHERE LNAME COLLATE FR_CA = :lname_search;
For the complete syntax of the WHERE
clause, see SELECT.