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)
Latest daily when built will fix up the collations.
that was a hacky bit of code.
No, that is a bug made by someone who did the queries: https://github.com/ShokoAnime/ShokoServer/blob/784dd4c087af3e800bee275cffd36c8e3f0c3968/Shoko.Server/Databases/MySQL.cs#L73