Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Question Unanswered: Sort order swedish едц

    Hi
    I have a table with a lot of customers that should be sorted A-÷ (swedish) the trouble is that д and е comes after a and ц comes after o.
    The sort order in the db is Swedish/Finnish.
    I have a lot of linked tables and files the linked tables comes from a db with Swedish/Finnish sort order.

    When I copy the customer table to a empty database and run the query the sorting is correct???

    Does anybody have idea??

  2. #2
    Join Date
    Aug 2003
    Location
    Belgrade
    Posts
    68

    Re: Sort order swedish едц

    Your original database was probably created with the incorrect sort order (not Swedish) and than later the sort order in Access was changed to Swedish/Finish. The new setting applies to all *new* databases you create *after* the change, but you can't alter the sort order in an existing database. That is way the sort order is correct in a new database but stays incorrect in the orginal one.

    The soultion would be to create a new database with the correct sort order and then to import all data and objects form the original database. But this may not work, if the original database was populated with data on a machine with the incorrect character set. Just an example: a german keyboard contains the ÷ character, but I am not sure it has the same character value as the ÷ character in the swedish character set.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •