Skip to main content

Character set in MySQL.

Sometimes this happens regional language stored in DB properly, but when rendered on UI it shows the question mark or special character even after the HTML character set is added. Solution for this is add the MySQL character set.

mysql_query (" set character_set_results='utf8' ");

// Add this before executing the sql query. OR in your connection file so it will be used through-out your application. For full reference, click here. 


//Adding HTML character set for reference purpose. (Read more at, W3Schools)

<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<meta charset="utf-8"> 

Comments

Post a Comment

Popular posts from this blog

Restoring MySQL on XAMMP

  Follow these steps and save your time and databases:- Go to your  XAMMP  installation, it’s mostly in  C drive . Now inside  mysql  folder rename the folder  data  to  data-old  (or any other name you like) Create a new folder  data  under  mysql  folder Copy the contents of  backup  folder to the new  data  folder Now copy all your  database  folders that are in  data-old  folder to the new  data  folder (skip the mysql, performance_scheme and phpmyadmin folder) And the last, copy the  ibdata1  file from  data-old  folder and replace it inside new  data  folder Restart your  MYSQL  server from  XAMPP control panel . And done!
Post a Comment
Read more

Setting default timezone in php.

Most of the time in shared hosting, default server time seems to be different than local timezone. You can change the default timezone using following snippet. date_default_timezone_set("Asia/Kolkata"); $dateTime = date("Y-m-d H:i:s", time()); //For full reference, visit. https://www.php.net/manual/en/timezones.php
Post a Comment
Read more