如何在SQL数据库中计算中文数值? [英] How to calculate chinese numericals in SQL Database ?

问题描述

大家好，

我正在用中文进行申请.
我想从输入页面将字符插入数据库，然后在SQL中对其进行一些计算.由于中文数值不同于正常的1,2,3.如何完成这些计算?

谁能解决我的问题?

谢谢，

Hi all,

I am making an application in Chinese language.
I want to insert the characters in the database from my input page then have some calculations on them in the SQL. As the Chinese numerical are different from normal 1,2,3. How can I get those calculations done?

Can anyone have solution to my problem ?

Thanks,

推荐答案

在我看来，没有简单的方法可以做到这一点.您需要创建自己的函数，该函数将(a)解析数字，(b)将其转换为阿拉伯数字，然后(c)计算它们.但是，此 Wiki文章 [ ^ ]可以帮助您创建自己的函数，因为它说明了^ ].

In my opinion, there''s no straightforward way to do this. You need to create your own function that will (a) parse the numbers, (b)convert them to their Arabic counterpart, and then (c)calculate them. However, this Wiki Article[^] can be helpful for you in creating your own function, since it explains the steps for conversion[^].

这篇关于如何在SQL数据库中计算中文数值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！