Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert using numeric format in different language

Status
Not open for further replies.

bessebo

IS-IT--Management
Jan 19, 2001
766
US
I am trying to do an insert into a table where the language is Dutch. In this language a comma is used for a decimal point. How can I insert using the comma as a decimal point without SQL thinking it is truly a comma? I tried using the Set Language Dutch command but I think this only applies to dates. Thanks in advance...

Bessebo
 

SQL Server only accepts a comma as a delimiter between numbers and not as a decimal separator. You must follow the SQL Server syntax or formatting when passing data to SQL. There is no workaround for this. Your application must send SQL Server data in the form and format expected by SQL Server. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top