EDN Admin
Well-known member
Hi<br/>
<br/>
a collegue of mine loads a Xml file that contains a XSD scheme<br/>
and also data into memory using DataSet.ReadXmlSchema.<br/>
The dataset is populated with datatables defined by the XSD<br/>
schema.
In one of these tables there is a primary key column<br/>
of type string, which of course only accepts unique values.<br/>
<br/>
Now there is a problem with a special german character http://en.wikipedia.org/wiki/%C3%9F" target="_blank" title="S Sharp ß <br/>
(unicode ß which is special version of s and is called S sharp.<br/>
This charcter is considered to equal the string ss.<br/>
Seems string comparison is kind of phonetic.<br/>
Thread.CurrentCulture is de-DE btw.<br/>
So if there is a key Groß in the DataTable, one can not <br/>
add another key Gross, because it violates the unique constraint.<br/>
<br/>
Now the question:<br/>
How can one force string comparison of type StringComparison.Ordinal? <br/>
Is there some switch in XSD or can one change some property of<br/>
the DataSet?<br/>
<br/>
Thanks,<br/>
Chris<br/>
<br/>
<br/>
<br/>
<br/>
<br/>
View the full article
<br/>
a collegue of mine loads a Xml file that contains a XSD scheme<br/>
and also data into memory using DataSet.ReadXmlSchema.<br/>
The dataset is populated with datatables defined by the XSD<br/>
schema.
In one of these tables there is a primary key column<br/>
of type string, which of course only accepts unique values.<br/>
<br/>
Now there is a problem with a special german character http://en.wikipedia.org/wiki/%C3%9F" target="_blank" title="S Sharp ß <br/>
(unicode ß which is special version of s and is called S sharp.<br/>
This charcter is considered to equal the string ss.<br/>
Seems string comparison is kind of phonetic.<br/>
Thread.CurrentCulture is de-DE btw.<br/>
So if there is a key Groß in the DataTable, one can not <br/>
add another key Gross, because it violates the unique constraint.<br/>
<br/>
Now the question:<br/>
How can one force string comparison of type StringComparison.Ordinal? <br/>
Is there some switch in XSD or can one change some property of<br/>
the DataSet?<br/>
<br/>
Thanks,<br/>
Chris<br/>
<br/>
<br/>
<br/>
<br/>
<br/>
View the full article