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_member156446]

using string would not be any performance issue.

[Former Member]

Hello Jay

Thank you . Do you have any information how to use Lraw data type in a normal table not in cluster table.

Regards

Chaitanya.A

[former_member156446]

never directly dealt with it.

[LRAW: Uninterpreted byte string of any length, but has to be declared with a minimum length of 256. Fields of this type must be located at the end of transparent tables (in each table there can be only one such field) and must be preceded by a length field of type INT2. If there is an INSERT or UPDATE in ABAP programs, this length field must be filled with the length actually required. If the length field is not filled correctly, this may lead to a data loss in the LRAW field! A fields of this type cannot be used in the WHERE condition of a SELECT statement.|http://help.sap.com/saphelp_nw70/helpdata/en/cf/21f2e5446011d189700000e8322d00/content.htm]

[Former Member]

Hi

My Source for filling the table is a XML file. In XML structure the filed which has huge data is of string type. my problem is when i am trying to assign a string value into the LRAW[CLUSTD] , lraw is converting all the characters in to 0s. so can you explain me how can i handle this.

Regards

Chaitanya.A

[Former Member]

Hi

I am considering string data type

Regards

Chaitanya.A