Data type with large size ?

[Former Member]

Guys,

I am working on a requirement where i need to create a table with 5 fields, out of ths 2 fields need to be char with size 400 and 9000. So my question is when i create a domain, what shall i use as data type ? i am not able to use 'CHAR' as it'll give a message that it exceeds the size, i tried 'LCHR', but in the table i got an error message that only one long characters can be used in a table at a time.

Not able to find out which one to use here,,, can anyone help plz ?? really stuck up here !!

[Clemenss]

Hi Kithu,

you can use STRING (or XSTRING) fields. Then there is no limit on the field size. As long as it is not (fully) filled with data, no space is wasted.

The disadvantage is that STRING type data are treated as 'deep' structures. That leads to some trouble in the definition of interfaces. Give it a try!

Regards,

Clemens

[Former Member]

Can't believe i missed 'String'.. Thanks a lot for your quick reply, It solved the issue.