Correct syntax looks like this. See MSDN. SELECT * FROM [FAEB].[dbo].[ExportaComisiones] AS f JOIN [zCredifiel].[dbo].[optPerson] AS p ON p.vTreasuryId COLLATE Latin1_General_CI_AS = f.RFC COLLATE Latin1_General_CI_AS
Try using COLLATE Latin1_General_BIN rather than COLLATE Latin1_General_CS_AS
COLLATE goes before the order direction: db.rawQuery(“SELECT ” + catName + ” FROM ” +tableName +” ORDER BY “+catName+” COLLATE NOCASE ASC;”, null); But you don’t need the ASC — that’s the default so you could just as well use: db.rawQuery(“SELECT “+ catName +” FROM “+ tableName +” ORDER BY “+ catName +” COLLATE NOCASE;”, … Read more
As I did not find a proper way I wrote a script to do it and I’m sharing it here for those who need it. The script runs through all user tables and collects the columns. If the column type is any char type then it tries to convert it to the given collation. Columns … Read more