Re: XMLTYPE and International Characters

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Mon, 19 Jan 2004 22:36:38 +0000
Message-ID: <8lmo00l52sdgsncda89csakptjkgnoi9rg@4ax.com>

On 19 Jan 2004 12:27:45 -0800, iblix_at_yahoo.com (Iblix) wrote:

>Database: Oracle9i
>Characterset: US7ASCII
>
>My xml document, however, contains international characters like
>French and Spanish letters with their accompanying accent marks.

US7ASCII doesn't have any accented characters in it, so you'd have to change your database character set, e.g. to WE8ISO8859P15 to be able to store them.

-- 
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

Received on Mon Jan 19 2004 - 16:36:38 CST