How to specify number of characters for tables that have columns of VARCHAR(n) data type?

[csubhodeep]

Hello all,

I am using MSSQL backend and have the following table in-memory

import ibis

t_local = ibis.memtable({"a": [1, 0, 3], "b": ['x', "yy", "abc"]})
print(t_local)

InMemoryTable
  data:
    PandasDataFrameProxy:
         a    b
      0  1    x
      1  0   yy
      2  3  abc

print(t_local.schema())

ibis.Schema {
  a  int64
  b  string
}

When I call the create_table on the above ibis.Table t_local, I always get the data type of column b on my database as VARCHAR(max). Is it hard-coded or default? If it is the latter, how could one set/specify it to something else, let's say 255?

[csubhodeep]

Closing in favour of #9382