Print

Print


Hello, all.  I'm going a little crazy with getting some unicode data
from MySQL to display properly in a web page, and wondered if you had
any ideas.

The records are in MySQL (4.1.21) with a utf8_unicode_ci collation.
When I view in phpmyadmin, everything looks fine.  If I run my query
in phpmyadmin, everything still looks fine, I can cut and paste the
record into the web page, and it displays fine, but when I grab the
data from MySQL it conks out:

http://www.ithacalibrary.com/research/unicode_test.php

I assume the problem is with my query or the connection, but I'm not
sure how I should do it.  I've tried explicitly setting the character
set like so:

SET names = 'utf8_unicodel_ci';
SET CHARACTER SET 'utf8_unicode_ci'

But this is voodoo to me--just saw it somewhere on the internets.

Am I missing something obvious?  Any ideas?

Thanks,

Andrew