Re: enum or tinyint?

2004-04-25 Thread Michael Stassen
Arthur Radulescu wrote: What is recommended for a large database to use enum or tinyint? Should I store active inactive or tinyint (1) with 0 and 1? Thanks, Arthur What matters to you, space, speed, or ease of use? A tinyint and an enum with just 2 values both take up one byte, so the space ques

139 Error: Table Handler Not Found

2004-04-25 Thread hpinson
Hi. I have encountered a MySQL 4.0.18 (Fedora Core 1) innodb problem which has been confirmed by the developers. If I define 16 consecutive text, mediumtext, or longtext fields, when the size of data exceeds 8000bytes, table updates fail (1030, 'Got error 139 from table handler). >From the MyS

Re: Unknown character set: 'latin1_swedish_ci'

2004-04-25 Thread Paul DuBois
At 8:04 -0500 4/25/04, Peter Brawley wrote: Anybody know the fix in MySQL 5.0.0-alpha for this error? PB What's the context in which you see this error? latin1_swedish_ci is a collation name, not a character set name. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.m

Unknown character set: 'latin1_swedish_ci'

2004-04-25 Thread Peter Brawley
Anybody know the fix in MySQL 5.0.0-alpha for this error? PB

enum or tinyint?

2004-04-25 Thread Arthur Radulescu
What is recommanded for a large database to use enum or tinyint? Should I store active inactive or tinyint (1) with 0 and 1? Thanks, Arthur -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: using oracle dev2000

2004-04-25 Thread dojie pornea
I've installed mysql 4.0.18 database server, and myodbc 3.51 driver on windows 98 machine. I've also installed Oracle Dev2000 as my front end. When I try to test the connection it connects successfully. When I try to add records using my design program in oracle dev2000 it works fine. My problem i