topic Data type with large size ? in Application Development and Automation Discussions

Data type with large size ?

Former Member — Sun, 18 Jul 2010 04:09:30 GMT

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 !!

Re: Data type with large size ?

Clemenss — Sun, 18 Jul 2010 04:25:15 GMT

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

Re: Data type with large size ?

Former Member — Sun, 18 Jul 2010 07:56:01 GMT

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