Devart Forums

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.

We cannot reproduce the problem. Please send to our support address complete sample that demonstrates the problem and include script to create server objects.