Mega Code Archive

 

Categories / Delphi / ADO Database

 

Oracles oracle 7 x odbc drivers, varchar2 255

Question: I am unable to see or edit data from my VARCHAR2 fields when they are defined as >255 in size. Answer: This is a problem that has been seen with only the Oracle ODBC drivers. "Live" TQueries can be used in this situation. The Oracle SQL Links drivers and Intersolv Oracle ODBC drivers do not exhibit the same behavior. As a general rule ODBC drivers should be ODBC level 2 compliant when used with the Borland Database Engine.