> CREATE TABLE `tracks` ( > `id` int(10) unsigned NOT NULL auto_increment, > `url` text collate utf8_unicode_ci NOT NULL,
When I run SHOW CREATE TABLE tracks, it reports "character set utf8", not "collate utf8_unicode_ci. CREATE TABLE "tracks" ( "id" int(10) unsigned NOT NULL auto_increment, "url" text character set utf8 NOT NULL, If I use MySQL Query Browser to examine the table, it reports for example that the tracks.url column has: Column Charset: utf8 Column Collate: utf8_unicode_ci The url column in track_statistics is reported with the same column charset and column collate. >Are you using the MySQL database delivered with slimserver or are you >using an external MySQL database ? >What operating system are you running slimserver on ? > I am using an external MySQL instance. SlimServer Version: 7.0a1 - TRUNK - Windows XP - EN - cp1252 Perl Version: 5.8.8 MSWin32-x86-multi-thread MySQL Version: 5.0.24-community-nt Phil _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
