Problem with Spanish on 2 machines

[Dale Hans]

I have tried searching and cannot find the answer to this.

My development environment
Window XP
ColdFusion MX7
MySql 4.1.12a-nt
Table def
WordStr - Varchar(35) default NULL
table Language latin1;

My production environment
Windows (unknown)
ColdFusion MX7
MySQL 4.1.12-log
WordStr - Varchar(35) default NULL
table Language latin1;

Here is my problem. Locally I am storing a Spanish string 'Analítico & Persistente' to the database table (note accent). When I retrieve it locally with my code, I get it back perfectly.

When I upload my code to my production server I get back: 'Anal￭tico & Persistente'!!

Same code, same table def, same data to start, same MySQL version, same language specification on the table, in fact... everything I can think to check is IDENTICAL!! What the heck can be the problem?? I am about to start pulling out hair I can't afford to lose.

I have tried changing the table def language to utf-8 on both ends, perfect local, messed up production.

Any ideas of what I can try / check?