[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)