Friday, February 10, 2012

Bulkload xml data

Is any one knowing how I bulkload data with characters like to SQL? I have no problem with common English characters. Is it anny parameters in the schema file or what?

Thanks for help Joel

Ps: I youse a schema file like this one...

<?xml version="1.0" ?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"
xmlns:sql="urn:schemas-microsoft-com:xml-sql" >

<ElementType name="namn" dt:type="string" />
<ElementType name="titel" dt:type="string" />
<ElementType name="datum" dt:type="string" />

<ElementType name="ROOT" sql:is-constant="1">
<element type="test" />
</ElementType>

<ElementType name="test" sql:relation="test">
<element type="namn" sql:field="namn" />
<element type="titel" sql:field="titel" />
<element type="datum" sql:field="datum" />
</ElementType>

</Schema>use unicode string type.

No comments:

Post a Comment