[DiscordArchive] Hello.When i try to import hotfixes db i get this error.someone know whats the problem?
[DiscordArchive] Hello.When i try to import hotfixes db i get this error.someone know whats the problem?
Original source
Hello.When i try to import hotfixes db i get this error.someone know whats the problem?
![[Image: unknown.png?ex=690c67b9&is=690b1639&hm=5...c52776b66&]](https://cdn.discordapp.com/attachments/376457124726702080/1002142812755730442/unknown.png?ex=690c67b9&is=690b1639&hm=59cdba4c6a62de28caa28696c68f87f4dc03387f4bec94679f2f4ebc52776b66&)
rektbyfaith
07-28-2022, 09:17 AM #1Archived author: Noll • Posted: 2022-07-28T09:17:45.722000+00:00
Original source
Hello.When i try to import hotfixes db i get this error.someone know whats the problem?
Original source
dont import it manually, let worldserver do it (the way you are doing it probably doesnt set utf8mb4 charset properly)
rektbyfaith
07-28-2022, 09:22 AM #2Archived author: Tea • Posted: 2022-07-28T09:22:05.581000+00:00
Original source
dont import it manually, let worldserver do it (the way you are doing it probably doesnt set utf8mb4 charset properly)
Original source
when i create db hotfixes should i change collation?default is latin1_swedish_ci
rektbyfaith
07-28-2022, 09:23 AM #3Archived author: Noll • Posted: 2022-07-28T09:23:19.834000+00:00
Original source
when i create db hotfixes should i change collation?default is latin1_swedish_ci
Original source
yes to utf8mb4_unicode_ci
rektbyfaith
07-28-2022, 09:24 AM #4Archived author: Tea • Posted: 2022-07-28T09:24:17.285000+00:00
Original source
yes to utf8mb4_unicode_ci
Original source
other db didnt have any errors so i guess they are good on default?
rektbyfaith
07-28-2022, 09:24 AM #5Archived author: Noll • Posted: 2022-07-28T09:24:41.495000+00:00
Original source
other db didnt have any errors so i guess they are good on default?
Original source
auth and char dont have any data in them, just structure
rektbyfaith
07-28-2022, 09:25 AM #6Archived author: Tea • Posted: 2022-07-28T09:25:03.004000+00:00
Original source
auth and char dont have any data in them, just structure
Original source
hotfixes has data in multiple languages
rektbyfaith
07-28-2022, 09:25 AM #7Archived author: Tea • Posted: 2022-07-28T09:25:11.774000+00:00
Original source
hotfixes has data in multiple languages
Original source
here is our generic script to create databases <https://github.com/TrinityCore/TrinityCore/blob/master/sql/create/create_mysql.sql#L5-L11>
rektbyfaith
07-28-2022, 09:25 AM #8Archived author: Tea • Posted: 2022-07-28T09:25:58.465000+00:00
Original source
here is our generic script to create databases <https://github.com/TrinityCore/TrinityCore/blob/master/sql/create/create_mysql.sql#L5-L11>
Original source
if you are doing this manually, at least use the same settings
rektbyfaith
07-28-2022, 09:26 AM #9Archived author: Tea • Posted: 2022-07-28T09:26:07.918000+00:00
Original source
if you are doing this manually, at least use the same settings
Original source
then i need to change collation of every base
rektbyfaith
07-28-2022, 09:27 AM #10Archived author: Noll • Posted: 2022-07-28T09:27:30.741000+00:00
Original source
then i need to change collation of every base