RESOLVED: Non-US numeric formats

Is there a way to indicate in either the XML document or a schema any of the the numeric format properties? For example, what the decimal separator is?

The problem is with an integer in an XML document that uses the comma as the decimal separator. When using SQLXMLBulkLoad3.Execute to bulkload an XML document into a SQL2K db, the number 12,34 (twelve point 34) is going in as 1234.

The SQL login user language has no effect. I have read, but have yet to find definitively, that SQL Server expects no other char than the period as a decimal point during input.

I want to know if I can indicate what the decimal separator is somehow, or do I have to format the XML to use periods as the decimal separator.

Thanks anyone.

As described here

http://msdn.microsoft.com/library/de...rence_6zlf.asp

it is not valid (at this time) to use a comma as a decimal separator or in any capacity in an XML document element defined as a numeric value by a schema (or probably style sheet too).

In case anyone was interested.