[Solved] Order by COLLATE

[mihmih]

Hi,

my base is connected to MYSQL. I have a problem with the order of the records in the queries created in the base. Is there any function (worked in HSQLDB) that allows such queries to be sorted by a specific language, in my case a polish language?

If I do

Code: Select all

ORDER BY column1 COLLATE utf8_unicode_ci 

and select SQLdirect, it works. But I would like it to work without directSQL. Does anyone know how to deal with it?

[Villeroy]

http://www.mysqltutorial.org/mysql-collation/

MySQL allows you to specify character sets and collations at four levels: server, database, table, and column.

[mihmih]

Ok, I had the appropriate COLLATION set, but there is still a problem with the letter 'Ł' in my language. But I used

Code: Select all

ORDER BY REPLACE (column_name, 'Ł'. 'LZ')