User Profile

Collapse

Profile Sidebar

Collapse
dushy
dushy
Last Activity: Jun 11 '07, 12:40 PM
Joined: Mar 26 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dushy
    replied to Utf-8 order by problem
    in Access
    do you mean that i need to put the order by 2 times???

    i get error
    Syntax error in ORDER BY clause

    when i do
    order by last_name ORDER BY last_name

    what do you mean?
    See more | Go to post

      Leave a comment:

    • dushy
      started a topic Utf-8 order by problem
      in Access

      Utf-8 order by problem

      hello all,

      I have a table that in ms access has a "first_name " and "last_name" fields
      all the data is in utf-8 encoding
      when i try to make a query like:

      SELECT * FROM myTable order by last_name;

      I get all the rows but they are not ordered alphabetically
      they are ordered by the utf-8 order.

      how can i get the rows orderd alphabetically?
      See more | Go to post
      • dushy
        started a topic Utf-8 order by problem
        in ASP Classic

        Utf-8 order by problem

        hello all,

        I have a table that in ms access has a "first_name " and "last_name" fields
        all the data is in utf-8 encoding
        when i try to make a query like:

        SELECT * FROM myTable order by last_name;

        I get all the rows but they are not ordered alphabetically
        they are ordered by the utf-8 order.

        how can i get the rows orderd alphabetically?
        See more | Go to post
        No activity results to display
        Show More
        Working...