Jump to content

Utf-8 order by problem


Recommended Posts

hello all,I have a table in ms access that has a "first_name" and "last_name" fieldsall the data is in utf-8 encodingwhen i try to make a query like:SELECT * FROM myTable order by last_name;I get all the rows but they are not ordered alphabeticallythey are ordered by the utf-8 order.how can i get the rows orderd alphabetically?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...