topic Re: Comparing LRAW datatype and STRING in Application Development and Automation Discussions

Comparing LRAW datatype and STRING

Former Member — Wed, 01 Jul 2009 03:51:49 GMT

HI All

I have a scenario where in i need to store a huge amount of data(ex. one Lakh characters) which is in Hexa decimal format in a single field of a table. I was going through some articles mentioning to use LRAW data type (CLUSTR AND CLUSTD) fields. Alternative approach is to use predefined data type as STRING and with length 999999, and i am able to achieve my scenario using string.

Now my doubts are

1) Is it recommended to use 999999 characters in a string , will there be any performance issue?

2) How can i use LRAW data type

Thanks and Regards

Chaitanya.A

Re: Comparing LRAW datatype and STRING

Former Member — Wed, 01 Jul 2009 07:01:42 GMT

hi,

usually to store large amount of binary data sap has provided LRAW type.

but you cannot use a field defined with lraw in your where statement.

generally performance issue wont be there in storing the data. whether it may be string or lraw. issue will come during the extraction of data

Hope this will surely help you!!!

thanks & regards,

punit raval.

Re: Comparing LRAW datatype and STRING

Former Member — Fri, 03 Jul 2009 07:43:35 GMT

I am considering string data type

Regards

Chaitanya.A