How mant Charates ?

want_tobe_dba · #1 (**permalink**) 04-15-08, 10:42

I have a question. I need to define 195000 charters. I would like to define in MB clob data type. How many MB would be good?

Any suggestions please

want_tobe_dba · #2 (**permalink**) 04-15-08, 11:13

ARWinner · #3 (**permalink**) 04-15-08, 11:14

For DB2 for LUW, the largest clob is 2 GB. I would either use that, as clobs are variable length entities.

Andy

want_tobe_dba · #4 (**permalink**) 04-15-08, 11:23

I definied 1MB CLOB assumed that 195000 =1 MB

stolze · #5 (**permalink**) 04-15-08, 13:33

It depends on your character set. If you have 1 single byte character set, e.g. UTF-8, then a single character can take up at most 4 bytes.

want_tobe_dba · #6 (**permalink**) 04-22-08, 14:23

it is single charater

195000*4 (B)=780000
780000/1024 =761.71875 KB
761.71875/1024=0.743865966796875 MB

thanks