My Oracle Support Banner

*XML Being Stored In The Wrong Way (Doc ID 2893219.1)

Last updated on SEPTEMBER 09, 2022

Applies to:

Oracle Database - Standard Edition - Version and later
Information in this document applies to any platform.


White space character is not preserved when inserting xml data into an XML column which is stored in a binary format.


create table test_xml (id number, b_xml xmltype, c_xml xmltype) XMLTYPE COLUMN "B_XML" STORE AS SECUREFILE BINARY XML XMLTYPE COLUMN "C_XML" STORE AS BASICFILE CLOB;

insert into test_xml (id,b_xml,c_xml) values (2, xmltype('<root> </root>'),xmltype('<root> </root>'));

select * from test_xml where id = 2;

<root> </root>


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.