[UCSF School of Pharmacy]

Peter,

Thank you for your prompt reply. Yes, I was using TINYTEXT. After altering the table so that they are VARCHAR it now works as I expect (but I still don't understand why it appeared to work for me before even when those columns were TINYTEXT). The book from which I learned MySQL compared CHAR versus VARCHAR and it also compared BLOB versus TEXT but it did not compare the TEXT data types to either CHAR or VARCHAR, so I think perhaps that is why I did not fully understand the limitations of using them or when to choose TEXT data types.

Thanks again for writing that great FAQ entry and for helping me out so quickly.

Frank

🙂

[Author]

Posts