Linked Questions

I'm new to spring, and I'm trying to print a list. When the page loads, the text doesn't display correctly. When I replace the return string from the jsp view name with one of the entries and adding ...

Update: SOLVED I just inserted charset=utfmb4 in my connection string and it worked. $pdo = new PDO("mysql:host=localhost;dbname=db_name;charset=utf8mb4", "db_user", "db_pass&...

I have a form from which i am taking user details.I am seeing that when the user enters character like ' there is an entry in the table but the character is entered as ? in the DB. For Example : If a ...

Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?

How can I convert entire MySQL database character-set to UTF-8 and collation to UTF-8?

I tried to import a large sql file through phpMyAdmin...But it kept showing error 'MySql server has gone away' What to do?

One of the responses to a question I asked yesterday suggested that I should make sure my database can handle UTF-8 characters correctly. How I can do this with MySQL?

I'm trying to connect to a MySQL database from Symfony 3 application. But when trying to create MySQL schema from a Symfony console command I get this error: PDO::__construct(): Server sent charset (...

I've googled a lot about this problem. To sum up, this is what my my.ini looks like: sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [client] database = abcdef user = root password = XXXXXX ...

I want to create a new db in mysql. I set utf8 as the default-character-set, but when I attempted to restart the db, mysql failed to restart and posted the following prompt: Trying to start the ...

I discovered (the hard way) that MySQL's UTF8 character set is only 3 bytes. A bit of research shows I can fix this by changing the tables to utilize the utf8mb4 collation and get the full 4 bytes UTF ...

THE SITUATION: Sorry in advance if this question has already been asked, but the solutions aren't working for me. No matter what I try, I cannot store emoji in my database. They are saved as ????. ...

I've made a simple PHP page to get the POST data and fetch a sql query then print the result. I'm using the mysql_fetch_array function. The code works great but the response is a non-Unicode text, ...

We ran an alter table today today that took down the DB. We failed over to the slave, and in the post-mortem, we discovered this in the mysql error.log InnoDB: ERROR: the age of the last checkpoint ...

I'd like every table and database (to be created) to be utf-8 that works with emojis. I understand that there are a few variables I need to define inside my.cnf: init_connect='SET ...