Special and accented characters in mysql generates bad symbols in PHP -


my collation set utf8_general_ci both on tables , fields. html has meta tag changes charset utf8.

when use php framework, such codeigniter, or use following queries before selecting database, see no problem on pages

mysql_query("set names 'utf8'"); mysql_query('set character_set_connection=utf8'); mysql_query('set character_set_client=utf8'); mysql_query('set character_set_results=utf8');

but i'm neither using kind of framework nor libraries, i'm working in company had project finished , noticed that, when save accented characters in database, example, "maçã" (apple in pt), seem stored fine mysql (at least when use phpmyadmin read table) displayed badly php/html. looks similar this:

ma< ?>< ?>

this known bad character question mark keeps coming everytime echo these words on code.

is there kind of configuration mysql or php solves problem (this specific one, i'm not talking general solution charset) once don't have keep correcting different functions , hacks?

i have realized utf8_encode on php side solves this. wanted kind of configuration appended config.php or sort of alter table. there out there?


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more