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

Simple method to connect database using PHP.

    $servername = "localhost"; $username = "root"; $password = ""; $dbname = "jjmtmain"; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) {     die("Connection failed: " . $conn->connect_error); } else {     echo "Connected to database."; }  /* In further operations you can use the $conn object for the database connection.              For eg. $q = mysqli_query($conn, "select * from user where email='$userid'"); $r = mysqli_fetch_array($q); echo $name = $r['name']; */
Post a Comment
Read more

PHP INI & ON PAGE ERROR REPORTING

  Enable-Disable on-page error reporting for debugging purpose.   //Turn off error reporting error_reporting(0); //Report runtime errors error_reporting(E_ERROR | E_WARNING | E_PARSE); //Report all errors error_reporting(E_ALL); //Same as error_reporting(E_ALL); ini_set("error_reporting", E_ALL); //Report all errors except E_NOTICE error_reporting(E_ALL & ~E_NOTICE); // Removing memory limit ini_set("memory_limit",-1); //Removing max execution time for php ini_set('max_execution_time', 0);
Post a Comment
Read more