Subject | sort order in firebird |
---|---|
Author | ming |
Post date | 2012-03-08T07:56:52Z |
hi all
i have a problem when sorting tib_query
exsample:
data in column :
AA
Aa
aA
AA
BB
ib_connection.charset=utf8,
result for above table, like below:
AA
Aa
BB
aA
aa
and should order like this:
aa
aA
Aa
AA
BB
the question how to fix sort order with
lowercase priority ?
i have a problem when sorting tib_query
exsample:
data in column :
AA
Aa
aA
AA
BB
ib_connection.charset=utf8,
result for above table, like below:
AA
Aa
BB
aA
aa
and should order like this:
aa
aA
Aa
AA
BB
the question how to fix sort order with
lowercase priority ?