Results 1 to 2 of 2
Thread: more utf-8 woes
Apr 6, 2008, 16:30 #1
more utf-8 woes
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci
Database Collation: utf8_unicode_ci
All tables: utf8_unicode_ci
All varchar, chars, etc.: utf8_unicode_ci
Server version: 4.1.22-standard
Why is it, that when I type ™©®, etc. into phpMyAdmin I see the characters as intended. However, when posting directly into mysql ($_POST['foo']) using PHP 5, and then looking at them again in phpMyAdmin I see crap?
if I print_r($_POST) in the PHP page, the characters are there, perfect.
If I insert directly via the post
It's only after the INSERT that I see the problem.
Apr 6, 2008, 19:07 #2
I fixed it. I modified my.cnf with
init-connect='SET NAMES utf8'