| **Navigation:**  SQL Driver Strings(General) >====== IGNORETRUNCATION ====== | [[getinfo.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[isolationlevel.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

**DRIVER('SQLDriver', '/IGNORETRUNCATION = TRUE | FALSE ' )**

**filelabel{PROP:IGNORETRUNCATION} = TRUE | FALSE**

{{blk2blue.jpg|blk2blue.jpg}}

(NOTE: Not valid for ORACLE Accelerator)

You can declare your string data to be a different size in Clarion than on the server. For example, you can define a CHAR(10000) as CSTRING(50) if all you are interested in is the first 50 characters of the data. However, doing this will generate an ODBC warning about string truncation.

By default, Clarion treats this as a normal error. If you want to ignore this warning, you can set \IGNORETRUNCATION=TRUE, or alternatively, use //filelabel{PROP:IgnoreTruncation} = 1//.