Results 1 to 2 of 2

Thread: RESOLVED: Non-US numeric formats

Threaded View

  1. Jun 7th, 2004, 12:18 PM #1
    vbmom
    vbmom is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2000
    Location
    NY
    Posts
    497

    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.
    Last edited by vbmom; Jun 11th, 2004 at 06:32 AM.
    end war
    stop greed
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width