Search code examples
mysqlmariadbinnodb

10.2.25-MariaDB not allowing data in multiple languages

Mysql version: 10.2.25-MariaDB

ENGINE=InnoDB

I'm trying to save data like: پہمغیابج ماوبرنم کرنامت

But it just shows question marks: ????

I have already tried:

Utf8, Utf8mb4 charset & utf8_general_ci, utf8_unicode_ci collation

but none of them seems to be working.

What charset or collation should I use to save data in multiple languages?

Update:

The same project is saving & retrieving data in multiple languages on my local machine (using mysql on local machine). But the server where I have deployed my code is using maria-db.

Update 2:

To make sure that its database issue and the client is sending correct data to db, I saved data to a text file just before saving it to database. The text file contains correct data but database has ??? in it.

Solution

  • I added charset=utf8 in connectionstring and it worked.