Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UTF8 text shows ???? when queried from db
- <?php
- header("Content-Type: application/json; charset=UTF-8");
- $server = "";
- $username = "";
- $password = "";
- $database = "";
- $con = mysql_connect($server, $username, $password) or die ("Could not connect: " . mysql_error());
- mysql_select_db($database, $con);
- $sql = "SELECT * FROM events WHERE id='1' ";
- $result = mysql_query($sql) or die ("Query error: " . mysql_error());
- $records = array();
- while($row = mysql_fetch_assoc($result)) {
- $records[] = $row;
- }
- mysql_close($con);
- print_r($records);
- ?>
- Array
- (
- [0] => Array
- (
- [id] => 1
- [event] => ????? ?????
- [speaker] => ???? ???????
- [area] => ???????
- [place] => ???? ??????
- [addr] => ??? ???? ????????
- [datefrom] => 2012-10-05
- [dateto] =>
- [timefrom] => 19:26:27
- [timeto] =>
- )
- )
- SHOW CREATE DATABASE `your_db_name`
- rowname varchar(100) COLLATE utf8_unicode_ci NOT NULL,
- $con = mysql_connect($server, $username, $password) or die ("Could not connect: " . mysql_error());
- mysql_select_db($database, $con);
- mysql_query('SET NAMES utf8');
- mysql_query('SET CHARACTER_SET_CLIENT=utf8');
- mysql_query('SET CHARACTER_SET_RESULTS=utf8');
- $sql = "SELECT * FROM events WHERE id='1' ";
- $result = mysql_query($sql) or die ("Query error: " . mysql_error());
Add Comment
Please, Sign In to add comment