Just so you know, and if anyone starts to look at Oregano Server, using it with SQL Server doesn't seem to be possible with the current code for it. I've been in contact with the guy who wrote it and told him of the problems.
Thanks for your responses Paul. Ade -----Original Message----- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 16:56 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes oH right - ( handy :) ) AFAIK there is no direct int type for double in mssql - however I do note In the past when porting mysql to access ( and then upsizing to mssql a few days later ) I had to alter the mysql double - to double float Before access could take the hint . -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 16:53 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes Hmmmm, I'm not sure I have that sort of controll over it. The Oregano server has an xml config file that you get to specify what datatypes map to: <tinyint dbType="TINYINT"/> <integer dbType="INTEGER"/> <bigint dbType="BIGINT"/> <double dbType=""/> <timestamp dbType="DATETIME"/> <varchar dbType="VARCHAR(255)"/> <longvarchar dbType="TEXT"/> so in Oregano timestamp maps to DATETIME in the DB. On boot up of the server, a temp table is created and it's metadata compared to the above values. So far double is the one that is playing up. In the mean time I'm gonna get it up and running with MySQL, see if that works ok. Thanks anyway :O) Ade -----Original Message----- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 16:13 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes Ah wait one .. * I think you can convert the mysql DOUBLE to DOUBLE FLOAT .. and then use that to update sql float * try with caution tho I haven�t tried it myself :) -----Original Message----- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 15:51 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes Hmm float should have been your man .. Try double precision -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 15:47 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] OT - MySQL Vs. SQL Server Datatypes Does anyone know the SQL Server datatype that maps closest to a DOUBLE in MySQL? I'm trying to set up Oregano Server for a chat room and the config files are based on MySQL so some changes are in order. I have tried FLOAT, REAL, NUMERIC, DECIMAL and MONEY but no joy with any of them. Also, has anyone ran Oregano live? Thanks Ade -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
