defining price column with mySQL

["Dave 'Duke of URL' Weiner" <davew@webmast.com>]

What is everybody setting the price column to in their mySQL tables?  I
currently have the column name as price, and I've tried decimal(8,2),
float(8,2) and char(12), but when I use the [sql-price] tag inside a [sql
type=list] [/sql] list, it just returns $0.00.  I know there are values in
the price column, and [sql-code] and [sql-description] work.

TIA,

Dave