Problem with TParam and UTF-8

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Yannis
Posts: 1
Joined: Wed 16 Aug 2006 14:53

Problem with TParam and UTF-8

Post by Yannis » Wed 16 Aug 2006 15:06

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.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Fri 18 Aug 2006 07:02

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

Post Reply