[BioSQL-l] Re: [Biojava-l] ontology exception, addSequence & BioSQLSequenceD B

[Simon Foote]

Hilmar Lapp wrote:

>On 10/16/03 8:41 AM, "Simon Foote" <simon.foote at nrc-cnrc.gc.ca> wrote:
>
>  
>
>>I also cc'd Hilmar, for possibly changing this in the biosql schema for
>>MySQL.  I far as I can tell it doesn't cause any problems with existing
>>databases as it only effects sorting and comparing of the field.
>>
>>    
>>
>
>You mean making all VARCHAR columns BINARY in the mysql version that
>constitute or are part of an alternative key?
>
>  
>
Yep, any VARCHAR field that is part of key where case sensitivity comes 
into play should be BINARY.

Simon

>Sounds reasonable to me. Also, would be consistent with the other 2
>supported platforms.
>
>Does anybody on this list have an opinion or comment for or against doing
>so?
>
>    -hilmar
>  
>