Hello,
I just try to insert in varchar2(2000) column with
- Oracle 9.2.0.1
- CharSet = UTF8
- Connection Name = Oracle (Core Lab)
- Driver Name = Oracle (Core Lab)
- Length of my string = 1400 (> 1/2 of 2000)
Result :
- When I execute my insert command in a TSQLQuery without parameter (all in dynamic code) => it works.
- When I execute my insert command in a TSQLQuery with a parameter and all my characters = 'a' => it works.
- When I execute my insert command in a TSQLQuery with a parameter and one character = 'é' and the rest of my characters = 'a' => I have an ORA-01461 error
Remark :
I don't have this error with :
- Connection Name = OracleConnection
- Driver Name = Oracle
I have to permit to insert accent characters.
So why I have this error and how can I resolve it ?
Thanks.