货币分隔符显示为，而不是。 [英] Currency delimiter showing as a , and not .

问题描述

我目前有一个SQL-server 2012运行我的应用程序



我有一个问题在我这边，那是在我的本地机器上我有货币值（rand）显示为R5000.00



我使用Visual Studio 2010将我的应用程序部署到服务器，当我在服务器上检查我的货币值时它显示为R5000,00



分隔符显示为不正确的分隔符。



我已检查区域设置和货币值分隔显示。

SQL数据库显示值为R5000.00



我该怎么做才能让分隔显示作为我的本地机器？（即R5000.00）

I currently have a SQL-server 2012 running an application of mine

I am having one issue on my side and that is on my local machine i have currency value(rand) showing as R5000.00

I deployed my application to the server using Visual Studio 2010 and when i checked my currency values on the server it is showing as R5000,00

The delimeter is showing as the incorrect delimeter.

I have checked on the Regional settings and currency value delimeter shows .
SQL database shows the Value as R5000.00

What could i do to get the delimeter to show as my local machine?(i.e. R5000.00)

推荐答案

什么样的应用程序？代码是否在服务器上运行？



你检查过服务器上的Region吗？代码运行的地方就是获取格式化信息的地方。



当你在SQL中检查值时，你是否从你的机器运行查询？这就是格式化信息的来源。



SQL Server不存储任何带有数字的格式。格式化由客户端在显示时完成。

What kind of application? Is the code running on the server??

Did you check the Region on the server? Wherever the code is running is where it's going to get the formatting information.

When you checked the value in SQL, were you running the query from your machine? That's where the formatting information is going to come from.

SQL Server does not store any "format" with numbers. Formatting is done by the client when it's displayed.

这篇关于货币分隔符显示为，而不是。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！