Enum TypeCode

public enum TypeCode

TypeCode is used as part of [Type][google.spanner.v1.Type] to indicate the type of a Cloud Spanner value.

Each legal value of a type can be encoded to or decoded from a JSON value, using the encodings described below. All Cloud Spanner values can be null, regardless of type; nulls are always encoded as a JSON null.

Namespace

Google.Cloud.Spanner.V1

Assembly

Google.Cloud.Spanner.V1.dll

Fields

NameDescription
Array

Encoded as list, where the list elements are represented according to [array_element_type][google.spanner.v1.Type.array_element_type].

Bool

Encoded as JSON true or false.

Bytes

Encoded as a base64-encoded string, as described in RFC 4648, section 4.

Date

Encoded as string in RFC 3339 date format.

Float64

Encoded as number, or the strings "NaN", "Infinity", or "-Infinity".

Int64

Encoded as string, in decimal format.

Json

Encoded as a JSON-formatted 'string' as described in RFC 7159. The following rules will be applied when parsing JSON input:

  • Whitespace will be stripped from the document.
  • If a JSON object has duplicate keys, only the first key will be preserved.
  • Members of a JSON object are not guaranteed to have their order preserved. JSON array elements will have their order preserved.
Numeric

Encoded as string, in decimal format or scientific notation format. <br>Decimal format: <br>[+-]Digits[.[Digits]] or <br>[+-][Digits].Digits

Scientific notation: <br>[+-]Digits[.[Digits]][ExponentIndicator[+-]Digits] or <br>[+-][Digits].Digits[ExponentIndicator[+-]Digits] <br>(ExponentIndicator is &quot;e&quot; or &quot;E&quot;)

String

Encoded as string.

Struct

Encoded as list, where list element i is represented according to [struct_type.fields[i]][google.spanner.v1.StructType.fields].

Timestamp

Encoded as string in RFC 3339 timestamp format. The time zone must be present, and must be &quot;Z&quot;.

If the schema has the column option allow_commit_timestamp=true, the placeholder string &quot;spanner.commit_timestamp()&quot; can be used to instruct the system to insert the commit timestamp associated with the transaction commit.

Unspecified

Not specified.

Extension Method