Search code examples
stringcratewkt

Is there any alternative to 32K string limits?

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);
Solution

  • 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.