Re: can't read SQL dump from MySQL

On Mon, Sep 11, 2000 at 03:46:26PM +0200, Andreas Jerke wrote:
> thanks for help,
> I fixed this with:
>
> CREATE TABLE Adresse (
> pid_adresse INT8 DEFAULT NEXTVAL('seqAdresse') PRIMARY KEY,
INT4 would do the job here.

> id_person int4 DEFAULT '0' NOT NULL,
> PLZ varchar(50),
> id_ort int4 DEFAULT '0',
> strasse varchar(50),
> id_postcode int4,
> hausnummer int4,
> zusatz varchar(25),
> postfach varchar(20),
> leitcode varchar(18),
> strassen_code char(3),
> FZ char(3),
> adresszusatz varchar(50)
> );

Integer Types

___mysql____________ postgress_____________
int1 = tinyint(4) - = 8Bit
int2 = smallint(6) int2 = 16Bit
int3 = mediumint(9) - = 24Bit
int4 = int(11) int4 = 32Bit
int8 = bigint(20) int8 = 64Bit

i think that the mysql syntax like tinyint(4) stands for less than 4 digist.

Chears,
Gunnar von Boehn
--
LinuxHaus Stuttgart | Tel.: +49 (7 11) 2 85 19 05
D-70734 Fellbach | Fax: +49 (7 11) 5 78 06 92
Linux, Netzwerke, Consulting & Support | http://lihas.de