[SOLVED] order letter ñ
lazarus / 16-Databases

----------------------------------------------------------------------
pbruccoleri · 2012-10-05 16:56

Hello..
I use: Lazarus 0.9.31 r30432 FPC 2.5.1 i386-win32-win32/win64 and ZEOS
7.0.0
Firebird 2.1.4- The database ir UTF8

I have a dbgrid, the TZqlquery associated have de sql text: select *
from articulo order by descripcion

but, the order is incorrect:
ZAPALITOS
ZILLERTAL
ÑOQUIS

what is the solution?
I use the IBExpert version 2012.9.2.1 and the result is the same when
i execute the same query.
very thanks

----------------------------------------------------------------------
taazz · 2012-10-05 17:14

the problem is in your database post the fields DML with the 
character set and collation it uses. the most obvious solution is to
use a different collation that knows how to sort correctly you
language. But I have no idea about that character or what is the
correct collation to use.

----------------------------------------------------------------------
Zoran · 2012-10-05 17:24

Try to change the SQL this way (add collate option to order by
clause):
Code: [Select]select * from articulo order by descripcion collate
unicode

----------------------------------------------------------------------
pbruccoleri · 2012-10-05 23:23

Hello..
with collate UNICODE was perfect!
very tnanks