dushy_d

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?

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?