Why the charset "UTF-8" chnaged to "WINDOWS-1252"
RakinMay 15 2008 — edited May 15 2008Hi,
The character set of my XML File is
<?xml version="1.0" encoding="UTF-8"?>
When I Insert this file into XMLType column with the statement (to save and to validate with XSD)
INSERT INTO xml_validate(warehouse_id,xml_file_name,warehouse_spec)
Values (agreementid,p_filename,XMLTYPE.createXML(l_clob));
The charset is changed to
<?xml version="1.0" encoding="WINDOWS-1252"?>
How can I save the file as it is, Because I also need to generate back the OS XML File from the stored CLOB.
Thanks in advance
Rizly