Ask for help DB error - Incorrect string value On CentOS 7

[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.

[Hergel]

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

[darksam]

 

Changing the database/table character set still gives the same error.

 

 

  On 11/17/2023 at 2: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;

 

Expand  

Edited November 18, 2023 by darksam

[darksam]

 

Changing the database/table character set still gives the same error.

 

 

  On 11/17/2023 at 2: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;

 

Expand  

[pandabro]

Did you fix it?

[masterzeus]

same problem, any solution?