Save pound symbol to database

[eluser]kirk112[/eluser]
Cheers Rob

I'm using

Code:

$this->db->query("SET NAMES 'latin1'");

And everything inserts correctly, quick fix for now, but long term need to change the database from UTF8 to latin1.

Can you think of any problem in storing the data as latin1 in a uft8 database?

Cheers

[eluser]Rob Gordijn[/eluser]
well kirk, I don't know the exact diffs between those two
I think a query on google (latin1 versus utf8) gives a lot stuff to read.

Did you try the second fix, with the content-typer header?
Ow, and did you try it in different browser?

[eluser]kirk112[/eluser]
after hours and hours and hours and hours and hours of messing changing / reading changing / testing /changing all I needed to do was add

Code:

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

To the header view.....

Leason learnt!

Thanks again Rob

[eluser]Rob Gordijn[/eluser]
ghehe, NP kirk.
Don't you just hate it sometimes, being a webdeveloper?