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