Special Characters in XML

There are a few characters in XML that need to be represented in a special fashion.

Character

Should be represented as

Comments

<

&lt;

left angle bracket

>

&gt;

right angle bracket

&

&amp;

ampersand

'

&apos;

single quote (an apostrophe)

"

&quot;

double quote


For example, this is invalid:

<table name="myTable" groupName="bread&butter" ...>


Replacing the ampersand with the proper escaped sequence yields valid XML:

<table name="myTable" groupName="bread&amp;butter" ...>

For more information on XML and its formatting, visit one of the many online resources, such as www.xml.com.

See Also

Tips & Tricks

Valid Ranges for Table and View id

Identifier lengths on Oracle databases

Database specific SchemaEditor files

XSD-based IntelliSense

Join Examples

SQL Views

Notes on Indexes

Next

Using CDATA for Text with Special Characters

Special Characters in XML