problems with text in spanish

Hi all, i have an applescript thats get records from FM Pro 6 and makes a record in mysql with

do shell script

the problem cames with words that has Ñ or ñ or ó,é etc, the result in mysql is NIÃ for an Ñ for exaple. I try to convert to unicode text but is the same thing. I have a similar problem when i do that for TextEdit.

Change the character set on the MySQL database to UTF-8.

thank u man, it has results

You’re welcome. I also work with Spanish and have UTF-8 set to default on my MySQL servers.