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

[Hilmar Lapp]

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?

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
-- 
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------