[Nhibernate-commit] nhibernate/src/NHibernate/Dialect MySQLDialect.cs,1.17,1.18

[Michael D. <mik...@us...>]

Update of /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv790/Dialect

Modified Files:
	MySQLDialect.cs 
Log Message:
Fixed a few minor problems with using MySql database.  Still have not 
figured out why we can't write to a varchar(x) binary field.

Index: MySQLDialect.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** MySQLDialect.cs	19 Jul 2004 03:24:02 -0000	1.17
--- MySQLDialect.cs	19 Jul 2004 13:52:26 -0000	1.18
***************
*** 16,36 ****
  		{
  			Register( DbType.AnsiStringFixedLength, "CHAR(255)");
- 			Register( DbType.AnsiStringFixedLength, 16777215, "MEDIUMTEXT" );
- 			Register( DbType.AnsiStringFixedLength, 65535, "TEXT" );
  			Register( DbType.AnsiStringFixedLength, 255, "CHAR($1)" );
  			Register( DbType.AnsiString, "VARCHAR(255)" );
- 			Register( DbType.AnsiString, 16777215, "MEDIUMTEXT" );
- 			Register( DbType.AnsiString, 65535, "TEXT" );
  			Register( DbType.AnsiString, 255, "VARCHAR($1)" );
  			Register( DbType.Binary, "LONGBLOB");
- 			Register( DbType.Binary, 16777215, "MEDIUMBLOB");
- 			Register( DbType.Binary, 65535, "BLOB");
  			Register( DbType.Binary, 255, "VARCHAR($1) BINARY");
! 			Register( DbType.Boolean, "TINYTINT(1)" ); 
  			Register( DbType.Byte, "TINYINT UNSIGNED" );
  			Register( DbType.Currency, "MONEY");
  			Register( DbType.Date, "DATE");
  			Register( DbType.DateTime, "DATETIME" );
! 			Register( DbType.Decimal, "NUMERIC(19, $1)");
  			Register( DbType.Double, "FLOAT" ); 
  			Register( DbType.Int16, "SMALLINT" );
--- 16,37 ----
  		{
  			Register( DbType.AnsiStringFixedLength, "CHAR(255)");
  			Register( DbType.AnsiStringFixedLength, 255, "CHAR($1)" );
+ 			Register( DbType.AnsiStringFixedLength, 65535, "TEXT" );
+ 			Register( DbType.AnsiStringFixedLength, 16777215, "MEDIUMTEXT" );
  			Register( DbType.AnsiString, "VARCHAR(255)" );
  			Register( DbType.AnsiString, 255, "VARCHAR($1)" );
+ 			Register( DbType.AnsiString, 65535, "TEXT" );
+ 			Register( DbType.AnsiString, 16777215, "MEDIUMTEXT" );
  			Register( DbType.Binary, "LONGBLOB");
  			Register( DbType.Binary, 255, "VARCHAR($1) BINARY");
! 			Register( DbType.Binary, 65535, "BLOB");
! 			Register( DbType.Binary, 16777215, "MEDIUMBLOB");
! 			Register( DbType.Boolean, "TINYINT(1)" ); 
  			Register( DbType.Byte, "TINYINT UNSIGNED" );
  			Register( DbType.Currency, "MONEY");
  			Register( DbType.Date, "DATE");
  			Register( DbType.DateTime, "DATETIME" );
! 			Register( DbType.Decimal, "NUMERIC(19,5)" );
! 			Register( DbType.Decimal, 19, "NUMERIC(19, $1)");
  			Register( DbType.Double, "FLOAT" ); 
  			Register( DbType.Int16, "SMALLINT" );
***************
*** 39,49 ****
  			Register( DbType.Single, "FLOAT" ); 
  			Register( DbType.StringFixedLength, "CHAR(255)");
- 			Register( DbType.StringFixedLength, 16777215, "MEDIUMTEXT" );
- 			Register( DbType.StringFixedLength, 65535, "TEXT" );
  			Register( DbType.StringFixedLength, 255, "CHAR($1)" );
  			Register( DbType.String, "VARCHAR(255)" );
- 			Register( DbType.String, 16777215, "MEDIUMTEXT" );
- 			Register( DbType.String, 65535, "TEXT" );
  			Register( DbType.String, 255, "VARCHAR($1)" );
  			Register( DbType.Time, "TIME" );
  			
--- 40,50 ----
  			Register( DbType.Single, "FLOAT" ); 
  			Register( DbType.StringFixedLength, "CHAR(255)");
  			Register( DbType.StringFixedLength, 255, "CHAR($1)" );
+ 			Register( DbType.StringFixedLength, 65535, "TEXT" );
+ 			Register( DbType.StringFixedLength, 16777215, "MEDIUMTEXT" );
  			Register( DbType.String, "VARCHAR(255)" );
  			Register( DbType.String, 255, "VARCHAR($1)" );
+ 			Register( DbType.String, 65535, "TEXT" );
+ 			Register( DbType.String, 16777215, "MEDIUMTEXT" );
  			Register( DbType.Time, "TIME" );