Subject | Re: Best character set |
---|---|
Author | gigmbh <ZJQBBYSESPEZ@spammotel.com> |
Post date | 2003-02-10T16:14:28Z |
> Regarding the added uppercased column, do you thinkIt depends.
> that there could be any inconvenience using case-insensitive
> collation drivers instead of the added column? On the end
> there is one less column in the table
> to deal with.
If sorting is the only issue you could also use a different collation
driver, but this does not ensure uniqueness regardless of caption on
primary keys.
So we tend to use nearly allways a seperate column. There is nothing
you have to deal with. Simply write a trigger which fills the
additional column and you are done.
Regards,
Frank.