This is what I found in the source (MsSql2000Dialect.cs Line: 59)

...
            // TODO: figure out if this is the good way to fix the problem
            // with exporting a DECIMAL column
            // NUMERIC(precision, scale) has a hardcoded precision of 19,
even though it can range from 1 to 38
            // and the scale has to be 0 <= scale <= precision.
            // I think how I might handle it is keep the
type="Decimal(29,5)" and make them specify a
            // sql-type="decimal(20,5)" if they need to do that.  The
Decimal parameter and ddl will get generated
            // correctly with minimal work.
            RegisterColumnType(DbType.Decimal, "DECIMAL(19,5)");
...


Should I log this into JIRA?


Yitzchok


On Mon, Dec 1, 2008 at 12:57 PM, Fabio Maulo <[EMAIL PROTECTED]> wrote:

> bug.Probably we forgot to update the XML parser to parse "precision,scale"
> because I remember that I change the dialect to support it.
>
> 2008/12/1 Yitzchok (adminjew) <[EMAIL PROTECTED]>
>
>> I tried this first
>>
>>     *<property name="SomeName" type="decimal(4,2)"/>*
>>
>> and I get
>> *
>> NHibernate.MappingException: Could not determine type for: decimal(4,2), for 
>> columns: NHibernate.Mapping.Column(SomeName)"
>>
>> *I used <*column */> because I needed access to *sql-type* (so I also
>> have to set the name)
>>
>> if I use *type="Decimal(4,2)" *then I get DECIMAL(19,5)
>>
>> Yitzchok
>>
>>
>> On Mon, Dec 1, 2008 at 12:35 PM, Fabio Maulo <[EMAIL PROTECTED]>wrote:
>>
>>> decimal(4,2)
>>
>>
>>
>>
>>
>
>
> --
> Fabio Maulo
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to