Is there any alternative to 32K string limits?

203 views Asked by At

I want to store WKT that can be quite large but I'm running into the 32K limit while storing them in object values.

create table A (id integer, wkt object);
1

There are 1 answers

0
claus On BEST ANSWER

So there is a way to store longer strings in objects:

CREATE TABLE IF NOT EXISTS A (
    "id" INTEGER,
    "wkt" OBJECT (IGNORED)
)

By using ignored the entire object is not indexed, which also prohibits it from being used in other SQL parts properly (they will always do a full table scan).

However, subscripts work just fine.

For other readers: WKT can also be stored as geo_shape type as well, or used with match directly.