error when insert new

[VipersGarden]

DaDaBIK version 10.3-Manarola pro, installed on 10-23-2020
PHP Version: 5.6.40-38+ubuntu16.04.1+deb.sury.org+1
mysql version: 5.7.32-0ubuntu0.16.04.1
Web server: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g mod_fcgid/2.3.9

Hello,
when I want a new insert with "strange" letters (turkish letter, etc.) for example "Ilgaz, Ç. & Kumlutaş, Y.," I get this:

[pre]
[08] Error: during query execution. INSERT INTO `pdf_lit` (`PDF_Nr`, `date`, `Autor`, `year`, `Titel`, `Journal`, `keywords`, `abstract`, `description`, `size`, `upload`, `upload2`, `upl2_txt`) VALUES ('16000', NULL, 'Ilgaz, Ç. & Kumlutaş, Y', NULL, NULL, 'turk zool journal', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
The DBMS server said: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xC5\x9F, Y' for column 'Autor' at row 1
[/pre]
and all is gone.

In my old version, those letters have been replaced by html code, like ş for ÅŸ.
so I only had to replace the wrong ones and not starting from the beginning.
Any chance to have this back?

thanks Mario

 

[eugenio]

Hello Mario,
which version were you using before?

If you have a database whose charset is correctly set as UT8 you don't have to replace anything, the characters will be correctly saved.

Best,