I have a text column in PostgreSQL that I am ordering by in ASC order and it is returning the following order:
SELECT column_A FROM table ORDER BY column_A ASC:
| column_A |
|---|
| IKvap06:52:22.52 |
| i.lost.all.my.tacos |
| IQKPb06:55:51.53 |
But I was expecting this:
| column_A |
|---|
| i.lost.all.my.tacos |
| IKvap06:52:22.52 |
| IQKPb06:55:51.53 |
Any ideas as to why/how this happening? Using locale: en_US.UTF8
I double checked the locale in the database instance to make sure it was en_US.UTF8. I can't seem figure out why I am getting this sort.