php - Entering values in database in unicode -


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