Option Compare Database

[jmcswain]

I want my database to by default use binary comparison, not text comparison. Anybody know how to do that?

[paulw]

? 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.

[jmcswain]

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;)

[paulw]

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.