Error in XML parsing that contain the French letter

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Error in XML parsing that contain the French letter

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-03-12 : 09:24:34

Niraj Kumar writes "DECLARE
@hDoc INT
,@TopasCurrencyXML VARCHAR(8000)
SELECT @TopasCurrencyXML = '<NewDataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Table" msdata:Locale="">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:attribute name="TPSCURRENCYCODE" type="xs:string" />
<xs:attribute name="TPSCURRENCYDESC" type="xs:string" />
<xs:attribute name="TPSLASTUPDATEDON" type="xs:string" />
<xs:attribute name="TPSLASTUPDATEDBY" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<Table TPSCURRENCYCODE="BEF" TPSCURRENCYDESC="Belgian Franc" TPSLASTUPDATEDON="08/06/2000 01:44:36" TPSLASTUPDATEDBY="ID044326" />
<Table TPSCURRENCYCODE="EUR" TPSCURRENCYDESC="European Standard Currency" TPSLASTUPDATEDON="06/06/2000 09:38:22" TPSLASTUPDATEDBY="T2" />
<Table TPSCURRENCYCODE="SDR" TPSCURRENCYDESC="Special Drawing Right" TPSLASTUPDATEDON="06/06/2000 09:38:22" TPSLASTUPDATEDBY="T2" />
<Table TPSCURRENCYCODE="FOR" TPSCURRENCYDESC="Franc Or - Calculated on the SDR/EURO exchange rate NO NEW RATES FOR CLEARCOM" TPSLASTUPDATEDON="05/12/2000 09:46:44" TPSLASTUPDATEDBY="ID077833" />
<Table TPSCURRENCYCODE="FRF" TPSCURRENCYDESC="Francs Français" TPSLASTUPDATEDON="06/06/2000 09:38:22" TPSLASTUPDATEDBY="T2" />
</NewDataSet>'

EXECUTE sp_xml_preparedocument @hDoc OUTPUT,@TopasCurrencyXML

INSERT into sptblTPSCurrData
(
TCurrencyCode
,TCurrencyDesc
,TLastUpdatedOn
,TLastUpdatedBy
)
SELECT
TPSCURRENCYCODE
,TPSCURRENCYDESC
,TPSLASTUPDATEDON--dbo.fnConvertXMLDateTime(TPSLASTUPDATEDON)
,TPSLASTUPDATEDBY
FROM OPENXML (@hDoc,'/NewDataSet/Table',1)
WITH
(
TPSCURRENCYCODE VARCHAR(3)
,TPSCURRENCYDESC NVARCHAR(100)
,TPSLASTUPDATEDON VARCHAR(23)
,TPSLASTUPDATEDBY VARCHAR(8)
)

EXEC sp_xml_removedocument @hDoc

Problem: I am trying to Parse the above XML in SQL server 2000 and I get error
XML parsing error: An invalid character was found in text content"

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-03-12 : 11:35:04

The problem relates to "=Francs Français". Whatever column relates to this needs to be unicode enabled.

This question came up recently either here or on sqlserversentral.com, with this solution already posted.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-03-12 : 12:27:57

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80260

www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources