Jump to content
  • 0

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


Question

Posted

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

image.jpeg.32dc4013e5194d59a4fa3ab52a485909.jpeg

image.jpeg.5801292d385f2e94bcca72a5e2b4ab0e.jpeg

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

  • 0
Posted (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 by Hergel
  • 0
Posted (edited)

 

image.thumb.png.bd48cedef8a9ed3ad5e8860ecc31fe0f.png

image.png

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 by darksam
  • 0
Posted

 

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;

 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...