[eluser]Max_Power[/eluser]
OK, I am having a similar problem in CI 1.7, too. It doesn't seem to be just putting the the GBP in the database that's an issue:
Code:
CREATE TABLE IF NOT EXISTS `options` (
`opt` varchar(63) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`option`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
In codeigniter:
Code:
$data = array(
'opt' => 'currency' ,
'value' => '£'
);
$this->db->insert('options',$data);
This puts in a '?' instead of a '£', even though the last_query() function displays the pound symbol correctly.
When the '£' symbol is retrieved, the active record set causes problems as it turns the '£' into '£'. Very strange.
mySQL version: 5.0.51a-3ubuntu5.4