PHP and MySQL encoding

Question

I have a problem with encoding.

A friend gave me his php/mysql project to check out. (db, tables, src -> utf8)

I have created and imported his stuff as utf8. Everything was fine until I added a new table to database. Then while encoding php<->mysql crushed, also things I didn't touch.(phpmyadmin still display good values, browser still utf8)

The solution was adding to my.ini file the following lines:

character-set-server=utf8
collation-server=utf8_general_ci

My friend made the same changes on his system, but we made a little test and another friend did the same as I had (adding a table) and it was fine without modifying .ini file.

My question is where potentially could the problem be?

It's important to me because some other friends want the same changes and I'd like to implement this without having them all alter their my.ini files.

mysql_set_charset(); is the preferred way to do it

dynamic
– dynamic

2012-02-08 15:58:14 +00:00
Commented Feb 8, 2012 at 15:58 — dynamic
– dynamic, Commented Feb 8, 2012 at 15:58
Just this: mysql_query("SET NAMES utf8");

m1k1o
– m1k1o

2012-03-13 13:24:54 +00:00
Commented Mar 13, 2012 at 13:24 — m1k1o
– m1k1o, Commented Mar 13, 2012 at 13:24

yen1k · Accepted Answer · 2012-02-08 15:49:58Z

3

Try this function in connection

mysql_query("SET CHARACTER SET utf8");

or

<?php
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
mysql_query("SET character_set_results=utf8");
?>

answered Feb 8, 2012 at 15:49

yen1k

5563 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP and MySQL encoding

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related