Hi,
static unsigned char UpperToLower[91] = {
0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,
17,
18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34,
35,
36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52,
53,
54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 97, 98,
99,100,101,102,103,
104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,
122,
};
I find that this table contains the UpperToLower conversion for English
characters. I need to have case insensitive sorting for Latin Characters
(for UTF-8). Is this case conversion planned as part of Sqlite3.0?
Where could I find the implementation of LATIN characters case insensitive
comparison? If I could find the C implementation for that I think I could
define a new collation function and implement that.
Please reply.
Thank you,
With regards,
Sankara Narayanan B