Problem with pound (£) in MySQL AR insert statements

Problem with pound (£) in MySQL AR insert statements

El Forum
Guest

04-12-2008, 12:54 AM

[eluser]Unknown[/eluser]
Using the following line of code, when $strFile includes the British pound symbol (£), I receive the error listed below. Has anyone else experienced this issue?

Code:

Code:
$this->db->insert('names', array('Name' => $strFile));

Result:

Code:
ERROR - 2008-04-09 01:01:34 --&gt; Query error: Incorrect string value: ‘\xA3.java’ for column ‘Name’ at row 1

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