TOraSession.Options
Posted: Wed 18 May 2005 09:09
Hello,
on an Oracle DB(9.2.0.6) I have defined a column as VARCHAR2(80) (in the creation script it is like VARCHAR2(80 CHAR)). When I use now TDBEdit field in my application it allows me to enter 240 characters instead of 80, as a result of this a get a "ORA-01401: inserted value too large for column" when trying to insert or update this column.
I now tested the CharLength property of TOraSession.Options but with no success, I have also tried to set the Charset to UTF8 or enable UseUnicode, also with no success.
How can I make the TDBEdit field work the correct way as to allow only the defined 80 characters in the field?
Can anyone help? Thanks a lot!
By the way, I am using ODAC4Net v. 4.50.3.24.
on an Oracle DB(9.2.0.6) I have defined a column as VARCHAR2(80) (in the creation script it is like VARCHAR2(80 CHAR)). When I use now TDBEdit field in my application it allows me to enter 240 characters instead of 80, as a result of this a get a "ORA-01401: inserted value too large for column" when trying to insert or update this column.
I now tested the CharLength property of TOraSession.Options but with no success, I have also tried to set the Charset to UTF8 or enable UseUnicode, also with no success.
How can I make the TDBEdit field work the correct way as to allow only the defined 80 characters in the field?
Can anyone help? Thanks a lot!
By the way, I am using ODAC4Net v. 4.50.3.24.