JJZolx;502487 Wrote: > Yes, I am. The titlesort column is type text, with a collation of > utf8_general_ci. The 7.3.4 SC database is running in the same database > server and the titlesort column is declared the same. > > I'll try running with the bundled MySQL server and a smaller test > library and let you know if there's any difference.
It works with the bundled MySQL server. I think I found the difference in the MySQL configuration options, where my server had sql-mode = "STRICT_TRANS_TABLES,..." which must have caused the error which rejected those queries as haviing invalid characters. Removing it results in no errors, but there's still a difference in the behavior between the bundled MySQL and the MySQL instance that I'm running in that the titlesort column gets truncated at the offending caracter on mine. titlesort = ANDRÉ PREVIN titlesort = ANDR Beyond that, there must be something very different between the INSERT statement being used to add music tracks and the one used to add directories. With music tracks there were no errors thrown previously, and there's no truncation. (BTW, the content_type = 'dir' entries in the tracks table are apparently only created by BMF. They're not created during a scan, which seems odd. If they're needed, why not create them during a scan?) -- JJZolx Jim ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=73507
_______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
