test "Binary NULL Types Without An Explicit :type", context do
    query("DROP TABLE bin_test", [])

    query(
      """
        CREATE TABLE bin_test (
          char char NULL,
          varchar varchar(max) NULL,
          nvarchar nvarchar(max) NULL,
          binary binary NULL,
          varbinary varbinary(max) NULL,
          uuid uniqueidentifier NULL
          )
      """,
      []
    )

    params_no_type =
      [
        %Parameter{name: "@1", value: nil},
        %Parameter{name: "@2", value: nil},
        %Parameter{name: "@3", value: nil},
        %Parameter{name: "@4", value: nil},
        %Parameter{name: "@5", value: nil},
        %Parameter{name: "@6", value: nil}
      ]
      |> Parameter.prepare_params()  # <-- exercise the changes in this PR

    assert :ok =
             query(
               """
               INSERT INTO bin_test
               (char, varchar, nvarchar, binary, varbinary, uuid)
               VALUES (@1, @2, @3, @4, @5, @6)
               """,
               params_no_type
             )

    assert [[nil, nil, nil, nil, nil, nil]] = query("SELECT TOP(1) * FROM bin_test", [])
  end

# $ docker run -e "ACCEPT_EULA=Y" -e 'MSSQL_SA_PASSWORD=Secret1@' -p 1433:1433 \
#     --platform linux/amd64 \
#     mcr.microsoft.com/mssql/server:2022-latest
Mix.install([
  {:tds, "~> 2.3"}
])

defmodule Main do
  def main do
    Logger.configure(level: :none)

    {:ok, pid} =
      Tds.start_link(
        username: "sa",
        password: "Secret1@",
        database: "master",
        port: 1433
      )

    # https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16#data-type-categories

    Tds.query!(
      pid,
      """
      CREATE TABLE #test_types (
        int int,
        bigint bigint,
        bit bit,
        decimal decimal,
        money money,

        float float,
        real real,

        date date,
        time time,

        char char,
        varchar varchar,
        text text,

        binary binary,
        varbinary varbinary,

        geography geography
      )
      """,
      []
    )

    names = ~w[
      int
      bigint
      bit
      decimal
      money
      float
      real
      date
      time
      char
      varchar
      text
      binary
      varbinary
      geography
    ]

    f = fn type ->
      for name <- names do
        sql = "insert into #test_types (#{name}) values (@value)"
        params = [%Tds.Parameter{name: "@value", type: type, value: nil}]

        case Tds.query(pid, sql, params) do
          {:ok, _} ->
            IO.puts("(#{type}) #{name} ok")

          {:error, %Tds.Error{message: nil, mssql: %{msg_text: message}}} ->
            IO.puts("(#{type}) #{name} error: #{message}")
        end
      end
    end

    IO.puts("type: :string")
    f.(:string)
    IO.puts("\ntype: :binary")
    f.(:binary)
  end
end

Main.main()