varchartostrlstsep default is now create - Caveat

In version 7, the default value for the varchartostrlstsep SQL property changed to create (it was previously lastchar). This simplifies the passing of Vortex string arrays to SQL strlst columns, especially when they may occasionally contain a single value.

Caveat: As a consequence, a single string such as "a,b,c," that was previously split into three values upon conversion to strlst, will be a single-value strlst ("a,b,c,") in version 7.

There are several ways to restore the version 6 default: set the [Texis] Varchar To Strlst Sep setting in conf/texis.ini; set the varchartostrlstsep SQL property; use the SQL convert() function with a third argument of "lastchar"; or set <vxcp compatibilityversion> to 6. See the Texis manual on these settings and the convert() function for details.


Copyright © Thunderstone Software     Last updated: Apr 15 2024
Copyright © 2024 Thunderstone Software LLC. All rights reserved.