Problem with pound (£) in MySQL AR insert statements

Problem with pound (£) in MySQL AR insert statements

El Forum
Guest

01-12-2009, 04:27 PM

[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

Messages In This Thread

Problem with pound (£) in MySQL AR insert statements - by El Forum - 04-12-2008, 12:54 AM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 04-12-2008, 05:03 AM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 04-12-2008, 05:08 AM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 04-12-2008, 05:11 AM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 04-12-2008, 07:10 AM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 04-12-2008, 08:04 AM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 04-12-2008, 09:10 AM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 04-13-2008, 07:43 AM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 04:27 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 04:36 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 04:50 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 04:57 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 05:02 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 05:14 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 05:21 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 05:28 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 05:40 PM

Problem with pound (£) in MySQL AR insert statements - by El Forum - 01-12-2009, 05:56 PM