darksam Posted November 11, 2023 Posted November 11, 2023 Try changing to use the OS Windows Server 2022 without any errors. Client Game use Thai language. Problems encountered on CentOS 7 [ SQL Error ] : DB error - Incorrect string value: '\xE0\xC3\xB4\xA8\xE9\xD2' for column `ragctro`.`vendings`.`title` at row 1 [ Debug ] : at vending.cpp:376 - INSERT INTO `vendings`(`id`, `account_id`, `char_id`, `sex`, `map`, `x`, `y`, `title`, `autotrade`, `body_direction`, `head_direction`, `sit`) VALUES( 1, 2000000, 150000, 'M', 'izlude', 126, 141, 'เรดจ้า', 0, '0', '0', '0' ); MariaDB Database Server MariaDB version 11.1.2 in file inter_athena.conf : set default_codepage: utf8mb4 // You can specify the codepage to use in your MySQL tables here. // (Note that this feature requires MySQL 4.1+) default_codepage: utf8mb4 Is there anyone who can solve this problem? Because I tried reinstalling and changing the version and it's still the same. Quote
0 Hergel Posted November 17, 2023 Posted November 17, 2023 (edited) Change Database/Table Character Set: If the current character set does not support Thai characters, you will need to alter your database and tables to use a character set that does, such as utf8mb4. This can be done with queries like: ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Also you can just re-create the db : CREATE DATABASE new_rathena_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Edited November 17, 2023 by Hergel Quote
0 darksam Posted November 18, 2023 Author Posted November 18, 2023 (edited) Changing the database/table character set still gives the same error. On 11/17/2023 at 9:40 AM, Hergel said: Change Database/Table Character Set: If the current character set does not support Thai characters, you will need to alter your database and tables to use a character set that does, such as utf8mb4. This can be done with queries like: ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Also you can just re-create the db : CREATE DATABASE new_rathena_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Edited November 18, 2023 by darksam Quote
0 darksam Posted November 18, 2023 Author Posted November 18, 2023 Changing the database/table character set still gives the same error. On 11/17/2023 at 9:40 AM, Hergel said: Change Database/Table Character Set: If the current character set does not support Thai characters, you will need to alter your database and tables to use a character set that does, such as utf8mb4. This can be done with queries like: ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Also you can just re-create the db : CREATE DATABASE new_rathena_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Quote
Question
darksam
Try changing to use the OS Windows Server 2022 without any errors.
Client Game use Thai language.
Problems encountered on CentOS 7
[ SQL Error ] : DB error - Incorrect string value: '\xE0\xC3\xB4\xA8\xE9\xD2' for column `ragctro`.`vendings`.`title` at row 1 [ Debug ] : at vending.cpp:376 - INSERT INTO `vendings`(`id`, `account_id`, `char_id`, `sex`, `map`, `x`, `y`, `title`, `autotrade`, `body_direction`, `head_direction`, `sit`) VALUES( 1, 2000000, 150000, 'M', 'izlude', 126, 141, 'เรดจ้า', 0, '0', '0', '0' );
MariaDB Database Server
MariaDB version 11.1.2
in file inter_athena.conf : set default_codepage: utf8mb4
// You can specify the codepage to use in your MySQL tables here. // (Note that this feature requires MySQL 4.1+) default_codepage: utf8mb4
Is there anyone who can solve this problem?
Because I tried reinstalling and changing the version and it's still the same.
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.