I would store whole cents in the database. EUR 10.99 would be stored as 1099 eurocent.
But yes, the mapping is what is missing and what you should look at. > On 05 Mar 2015, at 15:40, Esteban A. Maringolo <emaring...@gmail.com> wrote: > > Can you please share with us how are you defining the mapping for such field? > > > For what I was able to see in the current implementation the Pharo > dialect doesn't provide support for ScaledDecimals. > PharoDialect doesn't provide a #fixedPointType, so the number is > coerced to a float. > > > Adding support for it shouldn't be much hassle. Let me see if I can > spare a couple of hours to look into this. > > See comment of #convertToNumber:for: > "Convert to an arbitrary numeric type. Make sure our precision > matches. *Hate* floating point" > > :) > > > > Esteban A. Maringolo > > > 2015-03-05 11:16 GMT-03:00 Pablo R. Digonzelli <pdigonze...@gmail.com>: >> >> I know that. the problem is that glorp generates the string in question , >> not me. >> >> >> Ing. Pablo Digonzelli >> Software Solutions >> IP-Solutiones SRL >> Metrotec SRL >> 25 de Mayo 521 >> San Miguel de Tucumán >> Email: pdigonze...@softsargentina.com >> pdigonze...@gmail.com >> Cel: 5493815982714 >> >> ----- Mensaje original ----- >> De: "Werner Kassens" <wkass...@libello.com> >> Para: "Any question about pharo is welcome" <pharo-users@lists.pharo.org> >> Enviados: Jueves, 5 de Marzo 2015 11:04:01 >> Asunto: Re: [Pharo-users] scaled decimal number for currency >> >> do you perhaps mean this? >> b:=ScaledDecimal newFromNumber: 5.8777 scale: 2." 5.88s2" >> b printShowingDecimalPlaces:2." '5.88'" >> on a stream you can use 'printOn: aStream showingDecimalPlaces: >> placesDesired' >> werner >> >> On 03/05/2015 01:21 PM, Pablo R. Digonzelli wrote: >>> Hi, I want to use scaled decimal numbers for currency amounts. I am >>> using Glorp too. >>> The problem is that when Glorp generates sql sentences has a problem >>> with #printOn: of ScaledDecimal wich produces output that include the >>> scale value. >>> I do not want to modify printOn: on ScaledDecimal. Any suggestion for >>> this problem? >>> >>> TIA >>> >>> >>> >>> >>> **** >>> ------------------------------------------------------------------------ >>> *Ing. Pablo Digonzelli* >>> Software Solutions >>> IP-Solutiones SRL >>> Metrotec SRL >>> 25 de Mayo 521 >>> San Miguel de Tucumán >>> Email: pdigonze...@softsargentina.com >>> pdigonze...@gmail.com >>> Cel: 5493815982714 >>> >> >
