Oracle's in_char function lets you convert numbers into a text string, but it's an unusual facility to have as as built-in; there's no such facility (as far as I know) in MySQL but you can get around this easily enough within your controlling application - the Nums2Words module on the CPAN (in Perl), and a similar module on the PEAR (for PHP users) does all the hard work for you.

Here's a Perl example:

use Nums2Words;
@testvals = (7, 12, 153, -19, 1234007, 0.7,
  3.1415, 666.62, -176.75, 10.6e15);
foreach $number(@testvals) {
  $t1 = ucfirst(lc(num2word($number)));
  print "$number = $t1\n";
  }

When you run that, you get

earth-wind-and-fire:~/jun07 grahamellis$ perl n2w
7 = Seven
12 = Twelve
153 = One hundred fifty-three
-19 = Negative nineteen
1234007 = One million, two hundred thirty-four thousand, seven
0.7 = Zero and seven tenths
3.1415 = Three and one thousand, four hundred fifteen ten-thousandths
666.62 = Six hundred sixty-six and sixty-two hundredths
-176.75 = Negative one hundred seventy-six and seventy-five hundredths
1.06e+16 = One and six thousand, sixteen millionths
earth-wind-and-fire:~/jun07 grahamellis$

A web search lead me to similar code in Java, and no doubt there's someting in the Cheeseshop if you're a Python programmer. Lesson to be learnt - look around before you re-write code!
(written 2007-06-17 07:25:23)

 P219 - Perl - Libraries and Resources
S157 - More MySQL Commands

Back to A review of a week and a trip to Brugge

Previous and next or Horse's mouth home

Forward to Trying things in Python

End of File on a Java BufferedReader
The kind spirit of Melksham
What proportion of our web traffic is robots?
Trying things in Python
Outputting numbers as words - MySQL with Perl or PHP
A review of a week and a trip to Brugge
Horses of Brugge
Bathtub example
Sur le Continent
Commenting a Perl Regular Expression
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33 at 50 posts per page


This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).