I have a program using OleDbCommand to insert some chinese character
information into Oracle Database.
It runs normal except when data contains a particular chinese
character "¦â" and the exception message is ORA-00917 missing comma.

This is so strange for me since this is a very simple chinese
character and it could be inserted when I tested with other
applications(i.e. Oracle Financials).
Is this the problem of OleDbCommand of .Net?
Any idea?


Thanks and Regards,
Cherry

Hi,

Use parametrised commands (send values using parameters) and you'll be
(probably) fine.

I have a program using OleDbCommand to insert some chinese character
information into Oracle Database.
It runs normal except when data contains a particular chinese
character "¦â" and the exception message is ORA-00917 missing comma.

This is so strange for me since this is a very simple chinese
character and it could be inserted when I tested with other
applications(i.e. Oracle Financials).
Is this the problem of OleDbCommand of .Net?
Any idea?


Thanks and Regards,
Cherry

Simple problem: Why does this cause a massive memory leak?
How do you clear a datatable?
dataset designer - building data access layer - how to close connect on exception
Invalidate disconected recodset
Refresh not working on TableAdapter