topic Re: CHARACTER in Application Development and Automation Discussions

CHARACTER

Former Member — Fri, 15 Sep 2006 01:48:04 GMT

Hi,

im just curious, can anyone help me regarding this.

for ex. data: v_str type string,

v_char(10000) type c.

does v_char has no limitation aside to the number like '10000' you put. so any number i want i can put to this.

isn't it that type string has noh limitation, is type character the same as type string.

pls help me.

thanx in advance,

Re: CHARACTER

Former Member — Fri, 15 Sep 2006 01:52:47 GMT

Hi,

check this definition...

STRING for character strings

A string is a sequence of characters with variable length. A string can contain any number of alphanumeric characters. The length of a string is the number of characters multiplied by the length required for the internal representation of a single character.

Thanks,

Naren

Re: CHARACTER

Former Member — Fri, 15 Sep 2006 01:56:22 GMT

hi,

how about the character type, does it has a limitation or just like string which has a variable length.

thanx, jc

Re: CHARACTER

Former Member — Fri, 15 Sep 2006 01:58:55 GMT

Hi,

The maximum length specification for type C is 65535..

If you declare v_char(65536) it will give you a syntax error..

Thanks,

Naren

Re: CHARACTER

Former Member — Fri, 15 Sep 2006 02:05:52 GMT

hi,

does it mean that when my v_char(65535) is declare however my text lenght is more than 65355 the excess in 65535 will not be display. does my interprtation is correct.

thanx, jc

Re: CHARACTER

Former Member — Fri, 15 Sep 2006 02:09:07 GMT

Hi,

I think so...

Thanks,

Naren

Re: CHARACTER

Former Member — Fri, 15 Sep 2006 02:25:17 GMT

hi,

thanx to your help.

regards,