Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 32739 invoked from network); 29 Nov 2005 21:49:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 29 Nov 2005 21:49:05 -0000 Received: (qmail 72328 invoked by uid 500); 29 Nov 2005 21:49:05 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 72264 invoked by uid 500); 29 Nov 2005 21:49:04 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 72253 invoked by uid 99); 29 Nov 2005 21:49:04 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UPPERCASE_25_50 X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Nov 2005 13:49:04 -0800 Received: from ajax.apache.org (ajax.apache.org [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id C08B7C9 for ; Tue, 29 Nov 2005 22:48:41 +0100 (CET) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Tue, 29 Nov 2005 21:48:41 -0000 Message-ID: <20051129214841.16936.22615@ajax.apache.org> Subject: [Db-derby Wiki] Update of "Migration Tips" by Harrus X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by Harrus: http://wiki.apache.org/db-derby/Migration_Tips New page: = Migration Tips = Migrating other database to Derby and vice versa. == Overview of column types == === HSQL === ||<-3> '''Numerical'''|| ||INTEGER|INT||as Java type|| int | java.lang.Integer|| ||DOUBLE [PRECISION] | FLOAT||as Java type||double | java.lang.Double|| ||DECIMAL||No limit||java.math.BigDecimal|| ||NUMERIC||No limit||java.math.BigDecimal|| ||BOOLEAN | BIT||as Java type|| boolean | java.lang.Boolean || ||TINYINT||as Java type||byte | java.lang.Byte|| ||SMALLINT||as Java type||short | java.lang.Short || ||BIGINT||as Java type||long | java.lang.Long|| ||REAL||as Java type||double | java.lang.Double[1]|| ||<-3> '''Strings''' || ||VARCHAR || as Integer.MAXVALUE || java.lang.String|| ||VARCHAR_IGNORECASE || as Integer.MAXVALUE|| java.lang.String || ||CHAR || CHARACTER as Integer.MAXVALUE|| java.lang.String|| ||LONGVARCHAR || as Integer.MAXVALUE|| java.lang.String || ||<-3> '''Date and Time''' || ||DATE || as Java type|| java.sql.Date|| ||TIME || as Java type || java.sql.Time || ||TIMESTAMP | DATETIME || as Java type || java.sql.Timestamp || ||<-3> '''Binary data''' || ||BINARY || as Integer.MAXVALUE || byte[]|| ||VARBINARY || as Integer.MAXVALUE || byte[] || ||LONGVARBINARY || as Integer.MAXVALUE || byte[] || ||OTHER | OBJECT || as Integer.MAXVALUE || java.lang.Object|| === Derby === ||<-4> '''Numerical''' || ||Column type || Bytes || Range || Java Type || ||SMALLINT || 2 || -32768 java.lang.Short.MIN_VALUE - [[BR]]32767 java.lang.Short.MAX_VALUE||java.lang.Short|| ||INTEGER || 4 || -2147483648 java.lang.Integer.MIN_VALUE -[[BR]]2147483647 java.lang.Integer.MAX_VALUE ||java.lang.Integer || ||BIGINT || 8 || -9223372036854775808 java.lang.Long.MIN_VALUE -[[BR]]9223372036854775807 java.lang.Long.MAX_VALUE ||java.lang.Long|| ||REAL || 4 || Smallest REAL value: -3.402E+38[[BR]]Largest REAL value: 3.402E+38[[BR]]Smallest positive REAL value: 1.175E-37[[BR]]Largest negative REAL value: -1.175E-37 ||java.lang.Float || ||DOUBLE / DOUBLE PRECISION|| 8 || || || ||FLOAT (an alias for DOUBLE PRECISION or REAL )|| || || || ||DECIMAL (storage based on precision) || || || java.math.BigDecimal || ||NUMERIC (an alias for DECIMAL )|| || || java.math.BigDecimal || ||<-3> '''Strings''' || ||Column type || Max. size || Java Type || ||CHAR || 2147483647 java.lang.Integer.MAX_VALUE || java.lang.String || ||VARCHAR || 32672 ||java.lang.String || ||LONG VARCHAR || 32700 ||java.lang.String || ||CLOB || 2147483647 java.lang.Integer.MAX_VALUE || java.sql.Clob || ||<-2> '''Date and Time''' || ||Column type || Java Type || ||DATE || java.sql.Date || ||TIME || java.sql.Time || ||TIMESTAMP || java.sql.Timestamp || ||<-3> '''Binary data''' || ||Column type || Max. size || Java Type || ||BLOB || 2147483647 java.lang.Integer.MAX_VALUE ||java.sql.Blob|| ||CHAR FOR BIT DATA || 254 || java.lang.String || ||VARCHAR FOR BIT DATA|| 32672 || java.lang.String || ||LONG VARCHAR FOR BIT DATA|| 32700 || java.lang.String || === MySQL === ||<-4>'''Numerical''' || ||Column type || Bytes || From || To || ||TINYINT || 1 || -128 || 127 || ||SMALLINT || 2 ||-32768 || 32767 || ||MEDIUMINT || 3 || -8388608 || 8388607 || ||INT || 4 || -2147483648 || 2147483647 || ||BIGINT || 8 || -9223372036854775808 || 9223372036854775807|| ||<-3> '''Strings''' || ||Type || Max.size || Bytes || ||CHAR || 2^8-1 || 255 || ||VARCHAR || 2^8-1 || 255 || ||TINYTEXT || 2^8-1 || 255 || ||TEXT || 2^16-1 (64K-1) || 65535 || ||MEDIUMTEXT || 2^24-1 (16M-1) || 16777215 || ||<-2> '''Date and Time''' || || Column type || ``Zero'' value || || DATETIME || '0000-00-00 00:00:00' || || DATE || '0000-00-00' || || TIMESTAMP || 00000000000000 (length depends on display size) || || TIME || '00:00:00' || || YEAR || 0000 || || Column type || Display format || || TIMESTAMP(14) || YYYYMMDDHHMMSS || || TIMESTAMP(12) || YYMMDDHHMMSS || || TIMESTAMP(10)|| YYMMDDHHMM || || TIMESTAMP(8) || YYYYMMDD || || TIMESTAMP(6) || YYMMDD || || TIMESTAMP(4) || YYMM || || TIMESTAMP(2) || YY|| ||<-3> '''Binary data''' || || TINYBLOB || 2^8-1 || 255 || || BLOB || 2^16-1 (64K-1) || 65535 || || MEDIUMBLOB || 2^24-1 (16M-1) || 16777215 || || LONGBLOB || 2^32-1 (4G-1) || 4294967295 ||