FireBird 2.5 collate

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
k1attila1
Junior Boarder
Junior Boarder
Posts: 29
Joined: 24.05.2013, 06:38

FireBird 2.5 collate

Postby k1attila1 » 07.02.2017, 07:34

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
Gold Boarder
Gold Boarder
Posts: 589
Joined: 17.01.2011, 14:17

Re: FireBird 2.5 collate

Postby marsupilami » 07.02.2017, 09:30

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
Junior Boarder
Junior Boarder
Posts: 29
Joined: 24.05.2013, 06:38

Re: FireBird 2.5 collate

Postby k1attila1 » 07.02.2017, 09:34

Thank you Sir.
Ok. I Understand.


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest