Cannot insert degree symbol (°) through OCI

Question

I am using CodeIgniter with the OCI10 driver, and I have a problem introducing the degree symbol (°) into the database when using the binding . However the error message is empty

Message: Query ' INSERT INTO T1 (ID, TEXT) VALUES (1, 'text with °') ' was not executed; returned error: ''. 

When I use SQL Relay or paste manualy with SQL Developer, it works fine. Also, when I do not use binding, it is inserted correctly.

Answer 1

$ this-> db-> db_set_charset ('latin1', 'latin1_swedish_ci'); Use this when inserting a record.