I had to choose some time ago, but lets go: Firebird/Interbase cannot be used by mine projects since max lenght of an index is (or was) 254 bytes (imagine if you need to index 2 fields with 128 char unicode, or an timestamp + varchar(250) - it's impossible).
May be latest releases of Firebird/Interbase solved this limitations, but I really don't search news since then. I've kicked out Interbase 6 from my workstation to work with SapDB (7.2 in that time). And at that time, Java support was poor (I've contributed with Interbase java driver, but they never published a new binary release, so I needed to maintain myself - something that is not interesting). I'll suggest you to check item by item in capabilities of two databases... You will be safe from surprises in the future. Check mailing lists for known bugs... And difficulties that developers are facing... The two databases has a "dark side" (the SapDB one - IMHO - is that sometimes is hard to do admin tasks - hey, don't blame me: at least is not so easy as Interbase or MS SQL), but I think that Interbase has they dark side too (I've seen several corrupted databases, the java support was poor, no/poor ADO support, only commercial ODBC support and so on). SapDB has evoluted in admin tools - check WebDBM, that is great! I'm not firing Interbase, neither Firebird, neither SapDB. I just choosen SapDB because the large data volumn support (larger databases, transaction log, multiprocessor, multiplataform, great number of connections), and their interfaces (ODBC and JDBC) - that really work, and finally, because support mail lists is real cool (congratulations Sap guys - and girls ;-) ) ! My2c Edson Richter --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 25/3/2003 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
