Hi,
I have created a small form in which users enter the data in Spanish language, I store the data in DB and when i display it, then many of the characters are shown junk/garbage. I have the page charset encoding to UTF-8 but still the fonts doesn't show properly.

This problem is caused when i used the text boxes for first name, last name etc. as for the text area, i am using the fckeditor and its working fine.

Can you guide me how to fix the issue on the text boxes without using the fckeditor on it.

Regards,
David

I usually create tables using "DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci" and when I connect, I use "SET CHARACTER SET utf8" and "SET NAMES utf8" and then encode data with mysqli_real_escape_string before sending to the database. That's allowed me to work with things even as non-English as Japanese.