CodeIgniter Forums
Problem with active record insert - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Problem with active record insert (/showthread.php?tid=8192)

Problem with active record insert - El Forum - 05-08-2008

[eluser]fMertins[/eluser]
Hi guys, I´m doing an insert with $this->db->insert() and geting this error when the column content has special caracters like "ç" and "õ". I´m not usign magic_quotes... It seems CI is escaping these caracters but why this error happens?

Thank you in advance
Fernando


An Error Was Encountered

Error Number: 1366

Incorrect string value: '\xE7\xF5es d...' for column 'observacao' at row 1

INSERT INTO `pedido` (`idcliente`, `idcomprador`, `idprazo_pagamento`, `idtransportadora`, `situacao`, `data_entrega`, `data_cadastro`, `observacao`) VALUES ('3', '1', '2', '2', '0', '2008-12-23', '2008-05-08', 'Teste de observações do pedido, aqui o cliente/comprador pode digitar qualquer quantidade de texto, não tem limite...')

And here is the "desc" table:

Code:
mysql> desc pedido;
+-------------------+------------------+------+-----+---------+----------------+
| Field             | Type             | Null | Key | Default | Extra          |
+-------------------+------------------+------+-----+---------+----------------+
| idpedido          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| idcliente         | int(10) unsigned | NO   | MUL |         |                |
| idcomprador       | int(10) unsigned | NO   | MUL |         |                |
| idprazo_pagamento | int(10) unsigned | YES  | MUL | NULL    |                |
| idtransportadora  | int(10) unsigned | YES  | MUL | NULL    |                |
| situacao          | char(1)          | NO   |     |         |                |
| data_entrega      | date             | YES  |     | NULL    |                |
| data_cadastro     | datetime         | NO   |     |         |                |
| observacao        | text             | YES  |     | NULL    |                |
+-------------------+------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)


Problem with active record insert - El Forum - 05-09-2008

[eluser]fMertins[/eluser]
*** RESOLVED ***

Changed the options in config.php and database.php from UTF8 to ISO-8859-1/latin1, now it´s ok!

:-)

Nothing better than start programming next day with a free mind... :-P