strange characters keep showing up in db

[billybrag]

strange characters keep showing up in db

Hi all i am using a mysql database to run a script i found on the net, and strange things keep happening

The £ sign kees changing to either a ? or it adds a strange looking A to the front of it.

Any ideas what might cause this

Mike

[dkalweit]

strange characters keep showing up in db

Hi all i am using a mysql database to run a script i found on the net, and strange things keep happening

The £ sign kees changing to either a ? or it adds a strange looking A to the front of it.

Any ideas what might cause this

Mike

Some kind of code page/high ascii/unicode issue... Sorry I have no details on how to fix your problem, but this is most likely the root cause of it.


--
Derek

[J.D.]

If you see something like Â, then your application is pulling the £ symbol from the database in UTF-8, but your page is displaying it as something else. Changing your charset to UTF-8 should fix this problem:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

J.D.

[billybrag]

i have tried that but i think the problem is that the DB is outputting something that is not utf-8 ie things like � instead of £

please help

[J.D.]

i have tried that but i think the problem is that the DB is outputting something that is not utf-8 ie things like � instead of £

please helpCan you copy and paste these characters? Also, try connecting to MySQL from the console and select the record that contain these characters. Paste here the characters you get back.

J.D.