Comparing LRAW datatype and STRING

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi

I am considering string data type

Regards

Chaitanya.A