MySQL Forums
Forum List  »  Stored Procedures

Re: How to convert big numbers into word ?
Posted by: Peter Brawley
Date: July 28, 2019 10:04AM

It comes down to the same bit of logic over and over, so that kernel should need writing just once.

The rest is recursion over data, the data being the (English) names we give to powers of 10^n (n=0,1,2...). So write a table of names, then one module that iterates over all powers of 10 in any given number.

And to make it useful, make it simple to add French, Spanish, Japanese &c tables.

Options: ReplyQuote

Written By
Re: How to convert big numbers into word ?
July 28, 2019 10:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.