Posted by D. on 05/28/07 13:25

>
> What sort of strings do you expect? If the values will be digits and
> upper-
> case characters, you way want to consider a binary collation for the
> column,
> at least if your default collation is a Windows collation.
>

It sounds good!
Yes, my keys will be only uppercase and digits (some other symbols are
allowed, like dot and hyphen)

How do I set binary collation on a single column?
Do you think that this will improve performance on lookups?
Do you think that having a single column with a different collation will not
decrease performance?

Davide.

[Back to original message]