FireDAC Components for Couchbase

Build 21.0.7930

NumericStrings

Whether to allow string values to be treated as numbers.

Syntax


property NumericStrings: Boolean;

Data Type

Boolean

Default Value

true

Remarks

By default this property is enabled and the component will treat string values as numeric if they all the values it samples during schema detection are numeric. This can cause type errors later on if the field contains non-numeric values in other documents. If this property is disabled then numeric strings are left as strings although other string-based data types like timestamps will still be detected.

For example, the "code" field in the below bucket would be affected by this setting. By default it would be considered an integer but if this property were enabled it would be treated as a string.

{ "code": "123", "message": "Please restart your computer" }
{ "code": "456", "message": "Urgent update must be applied" }

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930