[nhibernate-issues] [NHJIRA] Created: (NH-2655) DbType.Double should be float(53) instead of DOUBLE PRECISION in the SQL-Severer2000 Dialect

[Nils A. (JIRA) <nh...@gm...>]

DbType.Double should be float(53) instead of DOUBLE PRECISION in the SQL-Severer2000 Dialect
--------------------------------------------------------------------------------------------

                 Key: NH-2655
                 URL: http://216.121.112.228/browse/NH-2655
             Project:  NHibernate
          Issue Type: Bug
          Components: DataProviders / Dialects
    Affects Versions: 3.2.0Alpha2
            Reporter: Nils Andresen


I am using NH to map c#-double values into SQL Server as floats. Everything works perfectly fine, however recently I tried running the SchemaValidator.

SchemaValidator fails:

Found: float, Expected DOUBLE PRECISION

Creating the tables using DOUBLE PRECISION works, but SQL Server will report the columns as float

The code for src/NHibernate/Dialect/MsSql2000Dialect.cs states 
RegisterColumnType(DbType.Double, "DOUBLE PRECISION"); //synonym for FLOAT(53)

IMO it would be better here to use the "real" type (float) istead of it's synonym.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira