2012-01-20, 23:03
I've just discovered that the Lifehacker article left out a crucial bit regarding setting the appropriate character set of the database so XBMC can properly write to it. The following mysql command should be run to create the databases and set the character set to latin1:
The lines above came from this How-To Geek guide, How to Sync Your Media Across Your Entire House with XBMC, and clarifies a few points missed by the Lifehacker article.
CREATE database xbmc_video CHARACTER SET latin1 COLLATE latin1_general_ci;
CREATE database xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;
CREATE database xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;
The lines above came from this How-To Geek guide, How to Sync Your Media Across Your Entire House with XBMC, and clarifies a few points missed by the Lifehacker article.