Quote:
Originally Posted by Quoth
Ah, so deletion & adding will STILL modify ALL the books with case-sensitive string match for the tag. Strange behaviour!
|
It is a Relational Database, so it is not strange.
When you add a new tag, its name goes into the 'Tags' table and it is assigned an index-number. To make data management/searching easy, the entry is normalized (case insensitive).
All the books refer to that Index-Number.
FWIW almost all other lookup equipped fields do similar (just no case insensitivity).