i want save data in hindi unicode format in database using php. have added few lines of codes database connection page.
mysql_query('set character_set_results=utf8'); mysql_query('set names=utf8'); mysql_query('set character_set_client=utf8'); mysql_query('set character_set_connection=utf8'); mysql_query('set character_set_results=utf8'); mysql_query('set collation_connection=utf8_general_ci'); also have added line page inputing , showing unicode data head attribute
<meta http-equiv="content-type" content="text/html;charset=utf-8"> but data storing in database '?????' , displaying in same format. new line character skipped thats data showing in single line.
i suspect database using different character set. make sure use create database with:
create database -- or 'alter database something' in case exists default character set utf8 default collate utf8_general_ci at moment telling query encoded in utf-8, database still using different character set.
also make sure output these data properly, encoded in utf-8 too.
Comments
Post a Comment