PostgreSQL uses the C library's locale facilities for sorting strings:
a A b B c C
Example:
Ruby | PostgreSQL |
---|---|
IMAGE3.jpg | image2.jpg |
image.jpg | image3.jpg |
image2.jpg | IMAGE3.jpg |
image3.jpg | image.jpg |
PostgreSQL-FAQ: Why_do_my_strings_sort_incorrectly Show archive.org snapshot