How to insert a float into a SQL table in the right locale (in .Net)

Posted by SoMoS on Stack Overflow See other posts from Stack Overflow or by SoMoS
Published on 2010-06-13T09:54:54Z Indexed on 2010/06/13 10:42 UTC
Read the original article Hit count: 231

Filed under:
|
|
|

Hello,

I have to insert float values into different SQL Servers. Each one can have different locales so in one it the representation could be "42,2" and at another one "42.2" or whatever. How should i construct the query so it works in any SQL Server?

Do i need to detect the locale of the server before constructing the query or what?

Thanks in advance mates.

© Stack Overflow or respective owner

Related posts about .NET

Related posts about sql-server