Try putting this into the Connection String for your mySQL DSN :

useUnicode=true&characterEncoding=ISO8859_1

You should find that helps with this as well as international characters.

Regards

Stephen

Paul Giesenhagen wrote:
> We have a problem and maybe someone has dealt with this before:
>
> Our Setup:
> CFMX 6.1
> MySQL 4.x
> Solaris
> Apache
>
> If I put ® into a textarea box, it goes into the database fine, I
> view the data in the database and it is still fine, I output it on a
> page and yet still fine, BUT, if I load that into a form Textarea, it
> changes it to a unknown box and thus if I click update transfers it into
> the database and IE displays it as a chinese character.
>
> So everything works until I bring it out of the database into a textarea
> form field ...
>
> Is this an IE setting, or what?  We have never had this problem before
> running on Windows 2k, CF5
>

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to