I want my database to by default use binary comparison, not text comparison. Anybody know how to do that?
Printable View
I want my database to by default use binary comparison, not text comparison. Anybody know how to do that?
? Default IS Binary
Taken from the Access help file... If you remove any Option Compare statements, then it will default to Binary.Quote:
If a module doesn't include an Option Compare statement, the default text comparison method is Binary.
Cheers,
Paul.
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;)
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.