When I change the language in Squeezebox Server to some languages the tracks_persistent table in the database gets incorrect collate setting. The problem is reproducible at least by changing language to Swedish(Svenska), Norveigan(Norska), Spanish(Espanõl). It is not reproducible by changing language to German or French.

The problem is that all tables besides tracks_persistent change collate setting with you change the language setting in Squeezebox Center. The result is that tracks_persistent get a different collate setting than the tracks table making it impossible to join them in database.

I've tried to perform a full rescan and also to delete the Cache/MySQL directory but it doesn't solve the problem.

When trying to get a list of all high rated tracks like this:
select * from tracks,tracks_persistent where tracks.url=tracks_persistent.url and tracks.url and rating>80;

The database answers with:
ERROR 1267 (HY000): Illegal mix of collations (utf8_spanish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

When checking the collate setting on tracks with "show create table tracks" it looks like this (some columns removed from output to shorten it):
CREATE TABLE `tracks` (
  ...
  `url` text collate utf8_spanish_ci NOT NULL,
  ...
  `content_type` varchar(255) collate utf8_spanish_ci default NULL,
  ...
  `vbr_scale` varchar(255) collate utf8_spanish_ci default NULL,
  ...
  `tagversion` varchar(255) collate utf8_spanish_ci default NULL,
  ...
  `musicbrainz_id` varchar(40) collate utf8_spanish_ci default NULL,
  ...
  `extid` varchar(64) collate utf8_spanish_ci default NULL,
  ...
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci


When checking the collate setting on tracks_persistent with "show create table tracks_persistent" it looke like this (some columns removed from output to shorten it):
CREATE TABLE `tracks_persistent` (
  ...
  `url` text NOT NULL,
  ...
) ENGINE=InnoDB DEFAULT CHARSET=utf8

As you can see there aren't any collate setting in the database on tracks_persistent which makes it impossible to join it with other tables, for example tracks.

I haven't found any problem with the standard Squeezebox Server functionality, but that's probably just because it never joins tracks_persistent with any other tables. I'm guessing that the Song Info page just reads directly from tracks_persistent instead of joining it with tracks.

However, it makes it impossible for third party applications to retrieve lists of tracks based on data in tracks_persistent. For example:
- TrackStat plugin
- Custom Browse plugin (with TrackStat based menus)
- SQL Playlist plugin (with TrackStat based statistics)
- muso integration (with TrackStat data)


It feels like all database tables besides track_persistent is affected by the user interface language setting.