chatlog error special characters

[Psyz 0]

[SQL]: DB error - Incorrect string value: '\xE1' for column 'message' at row 1
[Debug]: at log.c:422 - INSERT DELAYED INTO `chatlog` (`time`, `type`, `type_id`, `src_charid`, `src_accountid`, `src_map`, `src_map_x`, `src_map_y`, `dst_charname`, `message`) VALUES (NOW(), 'O', '0', '165109', '2000000', 'prontera', '100', '178', ?, ?)

I'm getting sql error, I already changed the encoding in the table to accept more than 4bits, but it still persists

[4144 364]

with codepages is hard. if you had already db and tables in wrong codepage, you may need change codepage for database for table and for column. or for all of them

depend how codepages used in your tables.

 

also need select codepage with 8 bits without validation. some codepages even if it's 8 bits, will throw errors on wrong chars.

 

[Psyz 0]

11 hours ago, 4144 said:

com codepages é difícil. se você já tinha banco de dados e tabelas na página de código errada, pode ser necessário alterar a página de código do banco de dados para a tabela e para a coluna. ou para todos eles

depende de como as páginas de código são usadas em suas tabelas.

 

também precisa selecionar a página de código com 8 bits sem validação. algumas páginas de código, mesmo que sejam de 8 bits, irão lançar erros em caracteres errados.

 

I did not perform any editing in the database.

the tables are also those of Hercules himself.

 

these characters are from the portuguese language (Brazil) in this case are accents (é, ão, você)

[4144 364]

hercules script not set locale for db, and hercules code not set it. this mean locale/codepage used default from your mysql server. and probably default is not what you want

because this need or change mysql config or/and change locale/codepage in db, tables etc

 

 

[Psyz 0]

so how can i fix?

[4144 364]

try change charset in database property, in table propery and each columns

 

also probably better set some good charset in mysql.conf or mariadb.conf (depend what sql software you using)

 

If you not sure what charset to set, try utf8mb4 or utf8mb4_general_ci. it should support any languages