Skip to content

Document empty bound parameters in the v5.6 empty-string guide #473

Open

Description

@Hanabi9248

The English and Chinese v5.6 guides describe converting an empty SQL literal to NULL. Applications that use bound parameters also need to know when an intentionally empty value is interpreted as SQL NULL. English guide Chinese guide

In the v5.6 extended query path, the server treats a parameter encoded as zero bytes as SQL NULL when the session uses the Oracle parser and ivorysql.enable_emptystring_to_NULL is enabled. The Bind check runs for each parameter before the server selects text or binary decoding, regardless of the declared parameter type. v5.6 Bind implementation

Document this behavior alongside the existing literal conversion explanation in both languages.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions