ShokoServer: Database encoding problem ( utf8mb4_unicode_ci is not default encoding for tables for mysql )

While importing collection I got one of this: [2018-03-18 12:02:18:915] Error|BackgroundWorker.OnDoWork => CommandProcessorGeneral.WorkerCommands_DoWork => CommandRequest_GetAnimeHTTP.ProcessCommand Error processing CommandRequest_GetAnimeHTTP: 8895 - NHibernate.Exceptions.GenericADOException: could not insert: [Shoko.Models.Server.AniDB_Anime_Title][SQL: INSERT INTO AniDB_Anime_Title (AnimeID, Language, Title, TitleType) VALUES (?, ?, ?, ?)] ---> MySql.Data.MySqlClient.MySqlException: Incorrect string value: '\xF0\x9D\x84\x87' for column 'Title' at row 1``

About this issue

  • Original URL
  • State: closed
  • Created 6 years ago
  • Comments: 22 (22 by maintainers)

Most upvoted comments

Latest daily when built will fix up the collations.

that was a hacky bit of code.