ODBC Driver for Couchbase

Build 24.0.9060

PeriodsSeparator

The character or characters used to denote hierarchy.

Data Type

string

Default Value

"."

Remarks

When flattening objects and arrays, the driver will use this value to separate different levels of objects and arrays. For example, if your Couchbase server returns a document like this (and FlattenObjects is enabled), then the driver will return the columns "geo.latitude" and "geo.longitude" if the periods separator is set to ".".

{
  "geo": {
    "latitude": 35.9132,
    "longitude": -79.0558
  }
}

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060