topic Maximum lenght for 'CHAR' data type in Application Development and Automation Discussions

Maximum lenght for 'CHAR' data type

Former Member — Wed, 27 Oct 2010 07:34:31 GMT

HI Experts,

I have created a table in which has one field of character type.The prob is when i create entries in the table for this perticular field,

the character is being truncated.. I have set the length of this char field to 255. but when i exceed it to say 500, then i get error stating 'Maximum length (255) for CHAR in transparent tables exceeded

Output length (1000) larger than maximum output length (255) in screens

plz help. as i have created the view for this table so i cant take this char field as string.

\plz suggest me, what could be the maximum length for char data type for transparent table.

Regards,

Ashmita Singh.

Re: Maximum lenght for 'CHAR' data type

Former Member — Wed, 27 Oct 2010 07:52:35 GMT

hi,

The maximun length for CHAR data type is 255 only.If u wnt to use longer character fields then u must choose the data type LCHR.

I hope this may help u

Thanks

Regards

Akhilesh Singh

Re: Maximum lenght for 'CHAR' data type

Former Member — Wed, 27 Oct 2010 08:29:57 GMT

I cant take lchar.

Re: Maximum lenght for 'CHAR' data type

Former Member — Wed, 27 Oct 2010 08:36:30 GMT

hi,

try this data element 'char1024'.

Regards,

Vijeta

Re: Maximum lenght for 'CHAR' data type

Former Member — Wed, 27 Oct 2010 10:04:35 GMT

Try this data element /SDF/CCM_XSTRING

Re: Maximum lenght for 'CHAR' data type

Former Member — Wed, 27 Oct 2010 15:00:13 GMT

Guys thanks for sharing, I had same requirement. I use these data element.

/BEV2/EDTEXTL INT2 5

/BEV2/EDTEXT L CHR 2000

Re: Maximum lenght for 'CHAR' data type

Former Member — Thu, 04 Nov 2010 14:16:57 GMT

Max of 255 applies to tables only. In memory (variable), the maximum size is 65535 for type c.