How to Output Query Result as UTF-16 XML
From: Bill Wordsworth <bill.wordsworth_at_gmail.com>
Date: Tue, 10 Jun 2008 09:46:58 -0700 (PDT)
Message-ID: <3d845310-60ac-4a66-97bc-df6bbe31e095_at_x41g2000hsb.googlegroups.com>
[Quoted] This is what I have done so far:
Date: Tue, 10 Jun 2008 09:46:58 -0700 (PDT)
Message-ID: <3d845310-60ac-4a66-97bc-df6bbe31e095_at_x41g2000hsb.googlegroups.com>
[Quoted] This is what I have done so far:
In Stored Procedure, I set-
* v_xml OUT NVARCHAR2
-
[Quoted]
- v_xml := '<?xml version="1.0" encoding="UTF-16" ?>...'; -- without any chr(10) newline
In Application, I set-
[Quoted] * header('Content-Type: application/xml; charset=UTF-16');
- mb_convert_encoding($v_xml, "UTF-16");
However, my data fetch keeps throwing parse error in IE/Firefox. And I keep getting my data as ASCII (mb_detect_encoding($v_xml)), not UTF-16? According to http://www.oracle.com/technology/tech/php/htdocs/php_troubleshooting_faq.html#nchar, "there is no NCHAR or NCLOB support in the OCI8 extension." And http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf makes no mention of UTF-16.
I am not sure how to get UTF-16 XML (or, how to make character set to
SQLCS_NCHAR if that would help)?
Cheers, Bill
Received on Tue Jun 10 2008 - 18:46:58 CEST