I thought my MySQL upgrade was really cool until I started having problems with the new "collation" stuff. Now it's driving me nuts!
Can someone explain to me in plain English what collation is all about and how to either get rid of it or deal with it? I used to import data into my tables via csv files and Navicat. I can now import csv files with my phpMyAdmin upgrade.
However, I have to go back and forth between the two because of collation, and sometimes neither one works. I wind up with columns that display 0 instead of (null) and appear to push other columns over into the wrong column.
And that's just my LOCAL problems. Publishing tables online is another problem, because my host hasn't upgraded to the latest MySQL yet.
One scheme I've thought of is to fill every NULL cell with something distinct, like XXX, then use PHP to somehow render XXX invisible, or null. Do you think that would work? And is anyone aware of a good collation tutorial? MySQL's website remains Greek to me. Thanks.