ORA-01406: fetched column value was truncated

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
Post Reply
User avatar
xutanou
Fresh Boarder
Fresh Boarder
Posts: 13
Joined: 14.03.2013, 16:42
Location: Catalunya

ORA-01406: fetched column value was truncated

Post by xutanou »

Good evening :D

After I had successfully connected to Oracle 10 XE, I had another problem... :cry: when using a zquery or a ztable in certain cases the program returned the oci error 01406 :evil: , I was shure that my database was ok and after a lot of temptatives and tests I found that the guilty of all that problem was the clientcodepage.... :P , I have not had to use this parameter in connections to Firebird or to Postgres, and that was the problem I didn't realize that that property was there :oops: , so:

If you have such a problem using zeos with Oracle (at least with 10 XE) you have to:

be shure that the property AutoEncodeStrings is set to TRUE and
select the proper code page in the dropdownbox of the Clientcodepage that matches your system code page, then:

enjoy this components !!! :jester:
Sharing your knowledge :book: makes you wise !!!
Post Reply