Results 1 to 4 of 4

Thread: Option Compare Database

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2000
    Posts
    400
    I want my database to by default use binary comparison, not text comparison. Anybody know how to do that?

  2. #2
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008

    Question ?????

    ? Default IS Binary

    If a module doesn't include an Option Compare statement, the default text comparison method is Binary.
    Taken from the Access help file... If you remove any Option Compare statements, then it will default to Binary.

    Cheers,

    Paul.
    Not nearly so tired now...

    Haven't been around much so be gentle...

  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2000
    Posts
    400
    No, the default sort option for a database is General, which is not case-sensitive.

    Therefore, if your primary key is text, "a" will come before "B", which is not what I want. I need my SQL statements to be in binary order. (SELECT fields FROM table ORDER BY a_binary_sorted_field


  4. #4
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    Sorry,

    It was the Option Compare title that threw me. To be honest I am not sure that you can do this (I assume you are using Access). I think that you would have to brute force re-order any dataset that was returned from your SQL statements (which is a bit crappy).

    Sorry again,

    Paul.
    Not nearly so tired now...

    Haven't been around much so be gentle...

Posting Permissions

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



Click Here to Expand Forum to Full Width