CHARACTER

[Former Member]

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,

jc

[Former Member]

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

[Former Member]

hi,

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

thanx, jc

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

I think so...

Thanks,

Naren

[Former Member]

hi,

thanx to your help.

regards,

jc