I'm having a terrible time with MySQL's new collation
feature. It frequently fills cells that should be NULL
with 0's and pushes data from one column to another. I
can usually import csv files into my tables using
either Navicat or phpMyAdmin, but I have to experiment
with a lot of settings, and sometimes it doesn't work
at all. Publishing tables online is yet another game,
as my webhost hasn't upgraded to the latest MySQL.
So I THINK I may have a good idea for a workaround. I
simply change all my fields to NOT NULL, then fill
every cell that would ordinarily be NULL with a unique
constant, like 606060.
Then I find some sort of PHP code that translates
606060 into NULL, ignoring it when both displaying
data and sorting table cells.
Does this sound like a workable solution, and does
anyone know how to actually implement it?
Thanks.
__________________________________
Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
