Thread: xml and utf-8

xml and utf-8

From
Perez
Date:
Any pointers/tricks/gotchas on storing XML into postgresql?  Is it any
more complicated than storing the XML into a bytea field?  Do I have to
worry about character encoding?  All my XML is in utf-8.

tia,
arturo

Re: xml and utf-8

From
"Gavin M. Roy"
Date:
If your DB encoding is UTF-8, I don't see why you can't use a TEXT
data type.

Regards,

Gavin

On Mar 2, 2006, at 7:07 PM, Perez wrote:

> Any pointers/tricks/gotchas on storing XML into postgresql?  Is it any
> more complicated than storing the XML into a bytea field?  Do I
> have to
> worry about character encoding?  All my XML is in utf-8.
>
> tia,
> arturo
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match