Posts: 3,110
Location: Toronto, Ontario
|
What charset are the forum pages being served in? If your site is serving visitors up iso-8859-7 pages for example, then they may be submitting content to the scripts in that charset. Remember that the bits for non-ASCII characters may be different in UTF-8 than they are in other charsets.
Both forums will have a way to change the charset, probably a per-language setting. Make sure the charset for the lang is UTF-8.
The reason they will work on the forums is because the forum script will be telling the browser the correct charset, which means the bits will match up with the correct characters. Then when you hop into phpMyAdmin, it is telling the browser that the charset is UTF-8, and the bits don't match the correct characters.
The charset/coalation in MySQL is only used when you perform string operations in a query. It has nothing to do with the actual content (in the database, strings are still just bits of data). It is how you use the strings (ie., what charset you send to the client) that determines which characters show up.
|