topic Storing long text in database table in Application Development and Automation Discussions

Storing long text in database table

Former Member — Mon, 27 Nov 2006 07:20:24 GMT

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

Re: Storing long text in database table

Former Member — Mon, 27 Nov 2006 07:23:55 GMT

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/Dev/Codes/Report/Z_TASK_LIST_LTEXT_UPLOAD.html

Regards

Kathirvel

Re: Storing long text in database table

anversha_s — Mon, 27 Nov 2006 07:28:26 GMT

no need for any FM

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

Re: Storing long text in database table

Former Member — Mon, 27 Nov 2006 07:41:09 GMT

Hi,

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

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

I hope this might be useful to you.

Regards,

Ramki.