Skip to Content
0
Former Member
Jul 01, 2009 at 04:14 AM

Comparing LRAW datatype and STRING

35 Views

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