Strange characters in MYSQL? =o(

[bmouthrob]

Hi all.

We have a strange problem.... To shorten a long story we had an access database which was shi.., well we all know what access databases are! ;oP

So I converted it to a MYSQL database. I only deal with the webside of the site as opposed to the content, although the guy who does this reported that there were some strange characters which had cropped up. For example some of the ones we have found so far (first is what it should be, then the code which the database has converted it to):

' IS CONVERTED TO ’
-- IS CONVERTED TO —
- IS CONVERTED TO •

At the moment i just have a replace in my asp code when displaying these characters, but he says that more are appearing!?

Should this be happening (as to me it seems like all these characters are used in SQL statements) or is there a problem somewhere along the line? We are using MYSQL 5 is that helps?

Any help appreciated!

Thanks
Rob.

[Scally_Ally]

By the looks of it maybe it could be the encoding type of your MySQL table or of the cells where the values are stored.

I had something similar when i was uploading data to a db and the enctypes had to be the same, otherwise strange characters started appearing. I changed to UTF-8 general and this seemed to solve the problem.

Ally