ORA-01406: fetched column value was truncated

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

ORA-01406: fetched column value was truncated

Postby xutanou » 19.05.2017, 19:02

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:

Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest