Tech Tip: The ARRAY STRING command in 4D v11 SQL
PRODUCT: 4D | VERSION: 11.3 | PLATFORM: Mac & Win
Published On: December 23, 2008
Databases created with 4D v11 SQL natively support Unicode, therefore there is no limitation of 255 characters on string length. In this context the ARRAY STRING command behaves as ARRAY TEXT.
It is strongly recommended for new development to use ARRAY TEXT instead of ARRAY STRING, to avoid inadvertently exceeding the limits of the array element size.
Commented by Jesse Pina on July 31, 2009 at 10:26 AM
For more details, this topic is covered in Chapter 12 in the 4D v11 SQL Upgrade manual, which can be found at the following link: http://www.4d.com/support/documentation.html