how to correctly insert a £ into mysql table so it shows as a £ and not A£

[jasonc]

I have been having problems getting the £ sign to be inserted as a £, what is the correct method to insert it in to mysql ?

[pastcow]

I think you need to make sure the DB table supports the correct charset and that when you display it from the DB its supporting the page you display it on sets the correct charset.

[jasonc]

i look at the database and it shows also as the

 

£12

 

the Collation is set as

 

latin1_swedish_ci

 

is that the right Collation for this character ?

[jasonc]

this is an extract of my mysql table...

CREATE TABLE IF NOT EXISTS `table` (
  `id` int(25) NOT NULL auto_increment,
  `additionalInfo` text NOT NULL,
  `cost` varchar(100) NOT NULL,
  `admin_reply` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

the fields that are not showing the £ sign are 'cost' and 'admin_reply'

[The Little Guy]

When you do your query:

 

mysql_set_charset('utf-8');
mysql_query("insert into table (...) values (...)");

[jasonc]

i tried that and also changed the databases collation to utf8_general_ci, and still the same thing ?

[The Little Guy]

what do you do when you pull the data out?

[jasonc]

ok i now got it to store in the mysql as a £ not the A£ using the following method..

 

placing

mysql_query("SET NAMES 'utf8'");

just below the call to mysql_select_db();

 

but still in the email text it shows as A£

 

the data is grabbed from mysql and placed in a string as is, then placed in a $_SESSION and then once the form is sumitted the new page formats the email text using strings and this is added to the email html, again none of these strings that have the £ are altered in anyway.

[The Little Guy]

Same thing:

mysql_set_charset('utf-8') == mysql_query("SET NAMES 'utf8'")

 

php recommends mysql_set_charset over mysql_query("SET NAMES 'utf8'")

 

when you pull the data out of the database, I don't think you want to use mysql_set_charset over mysql_query("SET NAMES 'utf8'"). I believe I had that problem once, by removing that, it came out normal (it may have been vise versa but I don't think so).

[jasonc]

so when i insert i use

mysql_set_charset('utf-8');

 

and when i grab i do not use the above ?

 

that is going to be really hard to do as the connection.inc file is in every file that uses a database connection !