各位大虾请教一个比较急的问题。
用xmlelement生成的CLOB中，中文字符乱码：
SQL> SELECT xmlelement("LINE",
2 xmlforest(
3 iol.ship_to_address2 AS c_ship_to_address2
4 )) AS contect
5 FROM oe_order_lines_all ool,
6 ibe_order_header_v ioh,
7 ibe_order_line_dtl_v iol
8 WHERE ool.header_id = 1986441 AND
9 ool.link_to_line_id IS NULL AND
10 ool.header_id = ioh.header_id AND
11 ool.line_id = iol.line_id AND
12 ioh.org_id = iol.org_id AND
13 ioh.order_number = 2000018
14 ORDER BY iol.line_number,
15 iol.shipment_number,
16 iol.option_number;
CONTECT
--------------------------------------------------------------------------------
ä¸ æ–?å —ç¬¦
但VARCHAR2显示却没有问题：
SQL> SELECT --xmlelement("LINE",
2 --xmlforest(
3 iol.ship_to_address2 AS c_ship_to_address2
4 -- )) AS contect
5 FROM oe_order_lines_all ool,
6 ibe_order_header_v ioh,
7 ibe_order_line_dtl_v iol
8 WHERE ool.header_id = 1986441 AND
9 ool.link_to_line_id IS NULL AND
10 ool.header_id = ioh.header_id AND
11 ool.line_id = iol.line_id AND
12 ioh.org_id = iol.org_id AND
13 ioh.order_number = 2000018
14 ORDER BY iol.line_number,
15 iol.shipment_number,
16 iol.option_number;
C_SHIP_TO_ADDRESS2
--------------------------------------------------------------------------------
中文字符
问了oracle也没回答。这会是什么原因，该怎么解决呢？谢谢！
DB：11.2.0.2.0
NLS_CHARACTERSET：UTF8，
NLS_NCHAR_CHARACTERSET：AL16UTF16
|
