Not getting proper JSON

BangaruBabu

07 Aug, 2015 12:49 PM

He llo All ,

Am very new to php , I am facing issue while rendering JSON data from mysql .

issue description
______________
In below Sample JSON we are getting special character("??????" ) in ArticleTitle . But that is not actual result . Actual data should be telugu regional language charecters . My ArticleTitle field is varchar datatype

function getUsers() {
//$sql = "SELECT user_id,username,name,profile_pic FROM users ORDER BY user_id";
$sql = "select vid as ArticleID ,title as ArticleTitle from node where type='article' and status=1 order by created desc";