Thursday, 18 May 2017

LocaleComapre when testing strings sorted in en-us utf8

I want to use localeCompare to test strings being sorted via Postgres.

The collation that is being used is en_US.utf8

When I use localeCompare to test sorting in descending and ascending it is giving me the incorrect result. What locale can I pass to localeCompare to handle this properly?



via MikeL

No comments:

Post a Comment