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