Page 1 of 1

PHP character encoding help

Posted: Fri Jun 13, 2008 4:38 am
by jake2891
Hi guys,

I have a text area which i populate with some data save it to the database. The problem is if i put 570£ when i use the pound symbol
it inserts strange characters into the databse. Anyone know why this would be happening as I am using iso-8859-1 as my forms charset and in the database itsself which im using Navicat im using the westEuropean character set. Here is the symbol its putting in 570£. Could this be a coding problem?

Re: PHP character encoding help

Posted: Fri Jun 13, 2008 11:39 am
by WebbieDave
Track down where the strange translation is occurring. Is Navicat converting it that way? Is it being converted when displayed back to you. If so, it could be a web server charset problem or a browser problem. Try a manual SQL INSERT using the db's native client to see if the problem occurs that way.

Re: PHP character encoding help

Posted: Fri Jun 13, 2008 1:16 pm
by RobertGonzalez
Remember that Navicat is a MySQL client interface, not the database itself. What is the collation on the table?