Help Needed with Sorting

fxh

I have a table column with the following data:

~ D
C
A
~ F
~ B
E


I'd like to sort it as:

A
C
E
~ B
~ D
~ F

But It gets sorted as

A
~ B
C
~ D
E
~ F

Any help would be appreciated

fxh

http://live.datatables.net/ocezan/2/edit#javascript,html

allan

What browser sorts your example incorrectly? I've just tried Firefox and Chrome and they sort it as:

[quote]
A
C
E
~ B
~ D
~ F
[/quote]

Allan

fxh

OK, solved:

I was using server-side processing, with a postgresql database. Issue was that my database locale was set to US. Workaround is to specify "COLLATE" for the relevant field

i.e SELECT * FROM MYTABLE ORDER BY MYFIELD COLLATE "C" ASC

Thanks