Matthew Stanfield said:For JDBC stuff, I've found that if you really want to call this a shortcoming, then that's about as far as you can take it
Hi,
Usually, i'll use "enum('0','1')" in place of a boolean type.
Curtis
[snip]
- the MySQL JDBC driver makes the BIT field act just like a single-bit field.
Regards,
Chris
well. The only annoying thing I can think of, from a programming perspective, is MySQL's lack of a Boolean type - the manual says use TINYINT(1) which works fine but is slightly annoying because of the extra type conversion needed every time you use it. Apparently MySQL will be implementing the Boolean type soon in accordance with whatever SQL standard requires it. Quite why it still has not been implemented, even though MySQL is into version 4, I have no idea - as a programmer I find this a staggering omission but presumably they have their reasons and perhaps most people are happy with TINYINT(1), but for clarity of code TINYINT(1) is inferior to a Boolean type.
I hope this helps,
..matthew
Jerry Apfelbaum wrote:
Hello.--
I have been tasked with evaluating open source databases for a large upcoming project: e-commerce, B2B, high availability.
The O/S is most likely to be Linux, although FreeBSD could possibly be used (lower probability).
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird are possible candidates.
Does anyone know why we should or should not use any of these? Does anyone know of other possibilities?
I’d very much appreciate hearing your comments and recommendations.
I have only recently started these evaluations. BTW, my own background is from the Oracle DBA world.
MySQL is certainly popular and seems to have very good performance, but I am concerned that the lack of Triggers, Stored Procedures, User-Defined Functions, and Views (to a lesser degree ) will be a disadvantage.
MaxDB "appears" to be more feature-rich and possibly more industrial-strength. How does its performance and stability compare to the others?
Many Thanks. Jerry Apfelbaum Toronto
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]