Best practice while creating tables - specifying the length of the data type

[Naveen]

Hi

I am using 2.3

Looks like ignite does not support CLOB, can I use varchar instead of CLOB
if my requirement is to store 100000 characters 

        CREATE TABLE MAP_CUST 
        (       
                PARTY_ID CLOB, 
                MAPPING_ID VARCHAR(1000) NULL, 
                UPDATEDBY VARCHAR(4000 CHAR) NULL, 
                SYNCREQUIRED VARCHAR(100) NULL, 
                ADB_SOURCE CHAR(1) NULL, 
                SYNCTO VARCHAR(10) NULL, 
                PRIMARY KEY (MAPPING_ID)
        )WITH "template=partitioned,backups=1,cache_name=MAP_CUST";

And, what is the best practice, do we need to specify the exact size or
omitting the size completely, which  one is efficient.

Thanks
Naveen



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/