FireBird 2.5 collate

[k1attila1]

Hello

I use special collate (PXW_HUN) for a varchar field. (codepage WIN1250)

Why do i get different resultset order if i use

ZTable SortFields-SortType properties or

ZQuery normal "select * form ...... order by ...."

Thnak you Attila Kovács

[marsupilami]

Hello Attila,

if you use the SortedFields, SortType and IndexFieldNames properties, sorting is done according to the settings in your Windows environment. If you sort by SQL "sexlect ... from ... order by ..." then sorting is done by the Server. Only in the second case the collation in your SQL query is used. If you use SortedFields and its friends, it doesn't matter if you sort the records on the server - they will always be sorted again on the client side.

With best regards,

Jan

[k1attila1]

Thank you Sir.
Ok. I Understand.