How to insert a float into a SQL table in the rigth locale

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:02 UTC
Read the original article Hit count: 266

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 sql-server

Related posts about localization