Thread: Problems with a very big string

Problems with a very big string

From
"Jo Candace"
Date:
Hi, I'm working with string very long(xml) of data type "text" in postgresql, but "text" does not support the length of string
 
somebody knows some way to work with this string(very long)?
 
Bye
 
Jessy

Re: Problems with a very big string

From
Richard Broersma Jr
Date:
--- Jo Candace <jocandace@gmail.com> wrote:

>  Hi, I'm working with string very long(xml) of data type "text" in
> postgresql, but "text" does not support the length of string
>
>  somebody knows some way to work with this string(very long)?

The text datatype is limited to a total size of 1 GB.  If you want to store more characters, to
could change your encoding to something much less featured.