Storing long text in database table

[Former Member]

If the length of the text which is very long is not fixed, how can we store it in a database table?

[Former Member]

You can make use of CREATE_TEXT, SAVE_TEXT and READ_TEXT for the same,

http://www.geocities.com/rmtiwari/main.html?http://www.geocities.com/rmtiwari/Resources/MySolutions/...

Regards

Kathirvel

[anversha_s]

Hi

<b>no need for any FM</b>

You need to create a table have a filed longer than 512 char, so you should use a field with a domain with type LRAW or LCHR (it can be longer than 512 char):

see the data element PC03_DSATZ for example.

When you create your table, before this field you have to insert a field type INT4 where you'll indicate the lenght of your text.

So your table should be:

MANDT key

NAME (Text Name) key

ZLENG (Type INT4)

TEXT (type LCHR)

Rgds

Anver

[Former Member]

Hi,

Even though, <b>PC03_DSATZ</b> hold only 2000 characters. It good to go for FM to incorporte this requirement.

Create a text objects using <b>SE75</b> transactions and use those Text Object ID, Text Id & etc.., thru FM's...<b>SAVE_TEXT, READ_TEXT</b>

I hope this might be useful to you.

Regards,

Ramki.