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.
SAP Sybase IQ 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.