Regional settings - decimal separator

You can get the decimal separator for the _user_ SQL Server is running under
from the registry. The key is HKEY_CURRENT_USER\Control
Panel\International\sDecimal, and you can read that key with the
undocumented extended procedure xp_reg_read. See
<a rel="nofollow" style='text-decoration: none;' href="http://www.mssqlcity.com/Articles/Undoc/UndocExtSP.htm" target="_blank">http://www.mssqlcity.com/Articles/Undoc/UndocExtSP.htm</a>

for a bit of unofficial documentation.

--
Jacco Schalkwijk
SQL Server MVP


"Kristoffer Persson" <hidden> wrote in message

 > Hi!
 >
 > I would like to know which decimal separator is used on a computer, from a
 > stored procedure.
 >
 > My stored procedure will insert a decimal value into a string, that must
 > be
 > formatted in a special way, and insert the string in a table. The problem
 > is
 > that decimal values in the string MUST HAVE the regional decimal separator
 > in order to work on the other end.
 >
 > Something like CONVERT(VARCHAR(20), 123.456, USE_REGIONAL_DEC_SEPARATOR)
 > would be nice.
 >
 > So, is it possible? If I need to use REPLACE(), then I need to know what
 > to
 > replace the dot with...
 >
 > - Kristoffer -
 >
 >
 >> Stay informed about: Regional settings - decimal separator 

SQL Server has no knowledge of the Windows setting that the client machine has which is connected
through a connection. I.e., asking for what decimal setting a connection's windows machine have is
impossible. You need to provide that information though the client application somehow.

--
Tibor Karaszi, SQL Server MVP
<a rel="nofollow" style='text-decoration: none;' href="http://www.karaszi.com/sqlserver/default.asp" target="_blank">http://www.karaszi.com/sqlserver/default.asp</a>
<a rel="nofollow" style='text-decoration: none;' href="http://www.solidqualitylearning.com/" target="_blank">http://www.solidqualitylearning.com/</a>
<a rel="nofollow" style='text-decoration: none;' href="http://www.sqlug.se/" target="_blank">http://www.sqlug.se/</a>


"Kristoffer Persson" <hidden> wrote in message
 > Hi!
 >
 > I would like to know which decimal separator is used on a computer, from a
 > stored procedure.
 >
 > My stored procedure will insert a decimal value into a string, that must be
 > formatted in a special way, and insert the string in a table. The problem is
 > that decimal values in the string MUST HAVE the regional decimal separator
 > in order to work on the other end.
 >
 > Something like CONVERT(VARCHAR(20), 123.456, USE_REGIONAL_DEC_SEPARATOR)
 > would be nice.
 >
 > So, is it possible? If I need to use REPLACE(), then I need to know what to
 > replace the dot with...
 >
 > - Kristoffer -
 >
 >
 >> Stay informed about: Regional settings - decimal separator 

"David Portas" wrote in message

 > Why would you store numeric formatting in a table?

I agree, but the only interface I have is to store a string formatted
according to the regional settings on the computer reading this information.

 > What would you do if two client PCs had different regional settings?

That wouldn't be very good, but I can assume that all PC's within the
network have the same regional settings.

Thanks for your input!

- Kristoffer -
 >> Stay informed about: Regional settings - decimal separator 

Thanks! I guess this is the path I'll have to walk.

- Kristoffer -

"Jacco Schalkwijk" wrote
in message
 > You can get the decimal separator for the _user_ SQL Server is running
under
 > from the registry. The key is HKEY_CURRENT_USER\Control
 > Panel\International\sDecimal, and you can read that key with the
 > undocumented extended procedure xp_reg_read. See
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.mssqlcity.com/Articles/Undoc/UndocExtSP.htm</font" target="_blank">http://www.mssqlcity.com/Articles/Undoc/UndocExtSP.htm</font</a>>
 >
 > for a bit of unofficial documentation.
 >
 > --
 > Jacco Schalkwijk
 > SQL Server MVP
 >> Stay informed about: Regional settings - decimal separator