Print

---

Andrew,

When I've had this problem before I needed to add the following the  
mysql connection string url:

&useUnicode=true&characterEncoding=UTF8

Duane

On Apr 10, 2007, at 12:55 PM, Andrew Darby wrote:

> 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