collation issues.

[Savas Zorlu]

Hi All,

I have a mysql database that I use with classic ASP. Database tables are set to utf_general_ci
My website's encoding is windows-1254

Most of the data inserted into the databse is through forms of the website.

My problem is:
special Turkish characters like ğşı are storded in the database as:
ðþý
and in binary they look even weirder (I cannot copy and paste those)
I see these characters corrupt when I lookinto data using the query browser; however on the website they are displayed correctly.



So I have no problems with that but my problem starts when I back the databse up aor try to transfer it to another server. In the back up sql's the special Turkish characters look corrupt so the back up is of no use.

I tried inserting data on a page where I set the page encoding to utf-8 but same thing happened.

I am really worried because if I ever need to perform a disaster recovery, my backed up data is useless.

Does anyone know a solution? Does anyone know how I can fix this?