Originally Posted by davidfor
But, if they are identical, why have them?
I hadn't thought about unicode. I was more thinking that for the Shortlist and Wishlist, that one would be the local word and used for display. The other would be the same every where used for linking in the database or other code. There isn't anything else that differentiates these shelves from the others.
Basically, searching for a unicode string requires a different SQL setup and query to a non-unicode string
Lazy SQL programming (Or outdated toolsets) basically means that you only implement the non-unicode search method, and pull the 'real' unicode string from a separate field.