Alan Gutierrez

Hacked Adam Gessaman’s Textile 2 Plugin to shell out to Why’s RedCloth / Textile & Markdown for Ruby.

Why? Because, I spend most of my day picking through my cut and paste, removing texturized do-dad’s like that single quote just went by and so called “double” quotes, which Textile will turn from " to matching quotes, except that if they are already there, cut and paste form on of the many word documents that Melanie Ehrlich likes to send me, then PHP Texile turns them into poison characters that leave little question marks in little diamonds, while RedCloth passes them right through.

Going from a 37Signals Writeboard or Backpack will bring these little dudes over, and then my posts are littered with funky characters. My dear, beloved users wonder what sort of web master I am. Am a I good or am I evil?

And, yes, WordPress does something wicked to XML example code. I exemplify XML to frequently to contenence this outrage. It will not do.

I updated the control panel, so you can set the path to RedCloth, and return to the strange world of PHP Textile using the radio button options. You can have this hacked plugin, but I don’t want to hear about how sloppy my additions to the code. It is as much PHP as I can stand for 2007 to have done this much.

I replaced the PHP implementation of Textile with RedCloth. Now I have the same Textile interpreter for all the 37Signals applications, Instiki, and WordPress. It is the ugliest hack.

Getting back to currency. The answer is simple. sprintf('%.2f', 10.8398274982734). Except it’s wrong.

That f in '%2f' is going to get you.

Whatever ActiveRecord says about currency, MySQL does not have a currency type. It does have a decimal type, however, and I’m not sure how well that maps to the ActiveRecord currency type, because currency is a sticky wicket.

You cannot use binary floating point numbers, like the kind you’ll use by default in most computer languages, because they are binary, and when you print the decimal representation, it is going to be off by a millismidge. You can assign a value to a floating point number, and ask for it right back, and find that is is off by a wee wee bit.

That is why there are decimal types that do the arithmetic we learned in grade school. They carry that one to the ten’s place, because to drop it is to short change a pensioner somewhere, and won’t that look bad. Every penny counts!

Actually, I don’t know how they implement arbitrary precision decimal types. Paul Christmann does, and he’ll tell us all about it in the comments.

Via Google, I find a very nice article on currency at CPAN in the documenation for Math::Currency, which is a Perl module, of course. The description section nails it.

There was a rambling discussion of why binary floats don’t work for currency in a thread on comp.lang.ruby called [Using Floats for Currency]. You can color on the screen with crayons while you read it.

That thread coughs up a Money class to play with.

The long and the short of it is, most database engines have a decimal type, they may call it currency, or they may call it decimial, or they may call it George, and they may hug it and squeeze it, but they are all very much not the same, so read the documentation for your particular database engine.

This advice repeated, in this article on OnLamp.com called SQL Data Types. Here’s a story about using the decimal type in MySQL that shows you how to use it through someone else’s trial and error.

At times, in my XSLT doodles, I’ve found myself without a decimal type, but with a need to tally currency.

The simplest way to do so, and to maintian precision, was to look at the amounts as a count of pennies. Here are some C programmers talking about the pennies trick. One dollar is represented as the integer 100. Credits, debits and summations turn out A-OK.

Becky has asked me something about currency in Ruby/Rails/ActiveRecord. I don’t know much about Rails/Ruby/ActiveRecord, but I was surpised to learn that Ruby programmers have no sense for collation. I was trying to explain to Becky that There Is More Than One Way To Do It, but I was wrong.

After showing here that she could sort by adding an :order => 'name' to the ActiveRecord::find method, I found that Ruby’s Array::sort had no way to do a proper collation. Thus, the only way that you could get your ‘a’ before your ‘B’ consistantly in Ruby would be to trust the underlying SQL engine. (Be warned, if you tell me to downcase or upcase you will be flamed.)

Squirt around the Internet looking for answers you’ll find none. Then to be malicious, I ran the search for ruby collation with a minor tweak that produced tons of intelligent responses. In Ruby land, collation is no.

Strange that this language from Japan has little support for i18n and l10n. What gives? Ruby obvously has support for Kanji, but none for Unicode. Is it not that important?