Store Chinese numbers


  • I want to store chinese number in database table and perform mathematical operations(e.g. Addition/substraction).

    Is it possible. What should be the datatype for column should or what database design changes needs to be done. Any sample code would be helpful.

    Also, the same table should also allow to store english numbers.

    Sunday, June 30, 2013 3:49 PM


  • You can store Chinese characters in nvarchar columns. You can have INT (or other numeric type) column for English numbers.

    Chinese letters example:

    You cannot perform math on Chinese numbers, only on numeric data types.

    Kalman Toth Database & OLAP Architect
    New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012

    Sunday, June 30, 2013 8:56 PM
  • What is the first rule of any tiered architecture? All display formatting is done in a presentation layer. You can get Chinesenumerals (NOT NUMBERS) in Unicode, and write a string function if you wish:

    Note: You may need East Asian fonts on your system to see the Japanese/Chinese characters in the table below.

    Hindu-Arabic Numeral Chinese Numeral Unicode
    1 一
    2 二
    3 三
    4 四
    5 五
    6 六
    7 七
    8 八
    9 九
    10 十
    100 百
    1000 千 
    10,000   万
    10,000    萬

    --CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL

    Sunday, June 30, 2013 10:12 PM

All replies