|
|
|
The maximum FairCom DB SQL field length has been increased to 8,192 bytes. The maximum field length in V8.14 was 2000 bytes. Any field requiring more than 2000 bytes required either a LONGVARCHAR or a LONGVARBINARY type. These long types presented challenges in handling as they have limitations including the impossibility of defining indices on them. The long types also preclude the ability to easily access data as they require particular handling when using ODBC and JDBC.
Note: If you add a field with the maximum size, you may be unable to create an index on the field unless you raise the server PAGE_SIZE setting as the key may be larger then the index node size.
