For some application developers, the Turkish letter I problem can cause significant problems. The correct solution is to ensure that all object references are in the proper case or that the proper form of the letter I is used. However, it may be more expedient to violate the Turkish rules in favor of the ANSI rules.
SQL Anywhere provides the collation 1254TRKALT, which is identical to 1254TRK, except that it makes I-dot and I-no-dot equivalent characters.
It is important to understand the consequences of this change. In a 1254TRKALT database, the following strings are equal:
This is not correct for a Turkish user, but may be acceptable for other users.
The second issue appears when using ORDER BY. Consider the following strings:
In a 1254TRK database, an ORDER BY of the strings would produce the following:
because I-no-dot is less than I-dot. In a 1254TRKALT database, the order would be
because I-no-dot is equal to I-dot.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|