topic Re: database tables in Application Development and Automation Discussions

database tables

Former Member — Fri, 11 May 2007 09:03:30 GMT

How to create a character field of length more than 255 characters(1035 characters) in a z database table...????

Thanks

Dhanashree..

Re: database tables

sreeramkumar_madisetty — Fri, 11 May 2007 09:05:43 GMT

You can use the Datatypes RAW and LRAW for this purpose.

Regards,

Sreeram

Re: database tables

amit_khare — Fri, 11 May 2007 09:07:18 GMT

Welcome to SDN.

Use data element CHAR1024 or CHAR1250.

Regards,

Amit

Reward all helpful replies.

Re: database tables

Former Member — Fri, 11 May 2007 09:07:36 GMT

type string sets the variable to a variable length.

Re: database tables

jayanthi_jayaraman — Fri, 11 May 2007 09:12:43 GMT

Hi,

Did you tried to use built-in-type as string?

Re: database tables

Former Member — Fri, 11 May 2007 09:13:46 GMT

hi,

just create a data domain with

data type as STRING

No of characters as required

its enough

reward some points.

with regards

suresh babu.

Re: database tables

Former Member — Fri, 11 May 2007 09:17:51 GMT

Hi,

Change field type as predeifned type STRING and specify field length.

This will do.

Jogdand M B

Re: database tables

Former Member — Fri, 11 May 2007 09:22:45 GMT

I used raw data type

Re: database tables

Former Member — Fri, 11 May 2007 10:04:53 GMT

Hi Dhanashree,

If you are using raw as data type the length should not exceed 255 .

Even though we are able to create domain and subsequently data elements fo having length more than 255 but we cannot use those in fields of table.

Thus kindly try to break the field into many componants.

Regards,

Saurabh