Sure, I was just curious if Firebird had a "money"-like value or if there
was some way to pull this off (without using a character type). I'm coming
from the sql server world where there is such a type that does in fact store
trailing zeroes.

No biggie, I can do the formatting on the front-end.

Thanks!

-v

_____

From: Martijn Tonies [mailto:m.tonies@...]
Sent: Tuesday, December 14, 2004 5:48 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Decimal point numbers


Hi,

> Will a decimal(9,2) maintain the trailing zeros on say, a monetary value?
>
> I need 10.10 not 10.1, for example.

What trailing zeroes are there on a number? Exactly: none.

This is a display issue, not a "value" issue.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=12913nv7m/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705115386:HM/EXP=1103114866/A=2455396/R=0/SIG=119u9qmi7/*http://smal
lbusiness.yahoo.com/domains/> click here

<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2455396/rand=944746227>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]