Skip to content

Latest commit

 

History

History
89 lines (81 loc) · 4.65 KB

README.md

File metadata and controls

89 lines (81 loc) · 4.65 KB
Raw

mssql-num2words

This is the TSQL container to help to convert money to words.

Alt text

About

This repo hopefully would be a somwhere for SQL Server Devs to come and take away the functions have been implemented for the multiple languages. So by the end, it will do:

  • Converting MONEY (with 2 decimal places) to WORDS
  • 100% TSQL (MSSQL) speaking
  • Already supported 30 LANGUAGES in popular
  • NOT Machine Learning, ONLY the ALGORITHM
  • TESTED in SQL SERVER 2019, but WILL WORK for THE OLDERS too

Support Languages

  • Arabic (AR)
  • Czech (CZ)
  • German (DE)
  • Danish (DK)
  • English (EN)
  • Spanish (ES)
  • Finnish (FI)
  • French (FR)
  • Irish (GA)
  • Hebrew (HE)
  • Hindi (HI)
  • Indonesian (ID)
  • Italian (IT)
  • Japanese (JA)
  • Korean (KO)
  • Kazakh (KZ)
  • Lithuanian (LT)
  • Latvian (LV)
  • Dutch (NL)
  • Norwegian (NO)
  • Polish (PL)
  • Portuguese (PT)
  • Russian (RU)
  • Slovene (SL)
  • Serbian (SR)
  • Telugu (TE)
  • Thai (TH)
  • Turkish (TR)
  • Ukrainian (UK)
  • Vietnamese (VI)

Installaton

  • Take the file /release/release_1_0.sql and compile into your database(s)
  • Open new query, and run somes to make sure that it is working:
SELECT dbo.MoneyToWords(9999, 'ar')--Arabic (AR):       تسعة آلَاف تسعة مِئَةٌ تسعة و تسعون 
SELECT dbo.MoneyToWords(9999, 'cz')--Czech (CZ):        devět tisíc devět set devadesát devět 
SELECT dbo.MoneyToWords(9999, 'de')--German (DE):       neuntausend neunhundertneunundneunzig 
SELECT dbo.MoneyToWords(9999, 'dk')--Danish (DK):       ni tusinde ni hundrede og nioghalvfems 
SELECT dbo.MoneyToWords(9999, 'en')--English (EN):      nine thousand nine hundred ninety-nine 
SELECT dbo.MoneyToWords(9999, 'es')--Spanish (ES):      nueve mil novecientos noventa y nueve 
SELECT dbo.MoneyToWords(9999, 'fi')--Finnish (FI):      yhdeksäntuhattayhdeksänsataayhdeksänkymmentäyhdeksän 
SELECT dbo.MoneyToWords(9999, 'fr')--French (FR):       neuf mille neuf cent quatre-vingt-dix-neuf 
SELECT dbo.MoneyToWords(9999, 'ga')--Irish (GA):        naoi míle naoi céad nócha a naoi 
SELECT dbo.MoneyToWords(9999, 'he')--Hebrew (HE):       תֵּשַׁע אֲלָפִים תֵּשַׁע מֵאוֹת תִּשְׁעִים וָתֵּשַׁע 
SELECT dbo.MoneyToWords(9999, 'hi')--Hindi (HI):        निन्यानवे हज़ार नौ सौ निन्यानवे 
SELECT dbo.MoneyToWords(9999, 'id')--Indonesian (ID):   sembilan ribu sembilan ratus sembilan puluh sembilan 
SELECT dbo.MoneyToWords(9999, 'it')--Italian (IT):      novemilanovecentonovantanove 
SELECT dbo.MoneyToWords(9999, 'th')--Thai (TH):         เก้าพันเก้าร้อยเก้าสิบเก้า
SELECT dbo.MoneyToWords(9999, 'ja')--Japanese (JA):     九千九百九十九
SELECT dbo.MoneyToWords(9999, 'ko')--Korean (KO):       구천구백구십구 
SELECT dbo.MoneyToWords(9999, 'kz')--Kazakh (KZ):       тоғыз мың тоғыз жүз тоқсан тоғыз 
SELECT dbo.MoneyToWords(9999, 'lt')--Lithuanian (LT):   devyni tūkstančiai devyni šimtai devyniasdešimt devyni 
SELECT dbo.MoneyToWords(9999, 'lv')--Latvian (LV):      deviņtūkstoši deviņsimt deviņdesmit deviņi 
SELECT dbo.MoneyToWords(9999, 'nl')--Dutch (NL):        negenduizendnegenhonderdnegenennegentig 
SELECT dbo.MoneyToWords(9999, 'no')--Norwegian (NO):    ni tusen ni hundre og nittini 
SELECT dbo.MoneyToWords(9999, 'pl')--Polish (PL):       dziewięć tysięcy dziewięćset dziewięćdziesiąt dziewięć 
SELECT dbo.MoneyToWords(9999, 'pt')--Portuguese (PT):   nove mil novecentos e noventa e nove 
SELECT dbo.MoneyToWords(9999, 'ru')--Russian (RU):      девять тысяч, девятьсот девяносто девять 
SELECT dbo.MoneyToWords(9999, 'sl')--Slovene (SL):      devet tisoč devetsto devetindevetdeset 
SELECT dbo.MoneyToWords(9999, 'sr')--Serbian (SR):      девет хиљада, деветсто деведесет и девет 
SELECT dbo.MoneyToWords(9999, 'te')--Telugu (TE):       తొంభై తొమ్మిది వేలు తొమ్మిది వందల తొంభై తొమ్మిది 
SELECT dbo.MoneyToWords(9999, 'tr')--Turkish (TR):      dokuz bin dokuz yüz doksan dokuz 
SELECT dbo.MoneyToWords(9999, 'uk')--Ukrainian (UK):    дев’ять тисяч, дев’ятсот дев’яносто дев’ять 
SELECT dbo.MoneyToWords(9999, 'vi')--Vietnamese (VI):   chín nghìn chín trăm chín mươi chín

Contacts

Have a touch to us via emails: Dat Nguyen, Nam Vu

Or via the socials: Facebook

At the end, welcome the PR(s) for any issue(s)!