Re: Tired of MYSQL and Character Set Problems!

[Steve Ross]

Let me add what I've tried that failed:

User enters data via an HTML TEXTAREA. They insist on copying from Microsoft Word and pasting, complete with the "smart quotes," ellipses, and dashes.

On table creation:

ENGINE=MyISAM; charset=utf8

In PHP:

SET NAMES utf8;
SET CHARACTER_SET utf8;

In generated HTML:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

The results:

Question marks on some browsers, lozenges (empty boxes) on others.

This is PHP5 served from Apache 2 on Fedora.

Any thoughts are appreciated.