Return
-
Title
Describe window of a table shows length of character datatype fields (CHAR and VARCHAR2) as 4 tim -
Description
User is performing a Describe of a table over a database link, the length of character datatype fields (CHAR and VARCHAR2) are shown as 4 times their actual size. That is a CHAR(1) field shows as CHAR(4) in the Describe window.
-
Cause
This is an issue with Oracle as the Data_Length field of SYS.ALL_TAB_COLUMNS view containing the incorrect lengths for Varchars in an AL32UTF8 database over a db link.
-
Resolution
Upgrade to the current version of Toad. The latest version of Toad can be downloaded from:
http://support.quest.com/support_download/Downloads.asp
The current version of Toad uses nChar_Length field of SYS.ALL_TAB_COLUMNS view in order to obtain the length of character fields.