Odp: [PHP-DB] Someone using the tool DeZign
Od: Ruprecht Helms [EMAIL PROTECTED] Temat: [PHP-DB] Someone using the tool DeZign does someone using DeZing as Tool for modelling databases? I have some trouble with the ImportER Access. I use this tool and I found it usable and comfortable in my work. AFAIK, ImportER Access is not as mature as other tools from Heraut, but what problem exactly do you have? Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Linux/PHP/Interbase
Od: "Todd Cary" [EMAIL PROTECTED] Temat: Re: [PHP-DB] Linux/PHP/Interbase I am still trying to find out which RPM I need to install... I think it's apache-devel, i also have RH 6.2 now! But, to be honest, you should go for apache 1.3.20, if it's possible, all up to 1.3.19 had some leaks... Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Re: interbase or postgres
Od: "Michael" [EMAIL PROTECTED] Temat: [PHP-DB] Re: interbase or postgres J-E-N wrote: just want to here comments from you guys. i will be doing a shopping cart and i'm still looking for the best database which i could use aside from Oracle.i'm still thingking which is better. interbase or postgres? Just a few comments - Postgresql has a larger range of data types and built in string functions, Interbase has no text datatype and (I think) "like" doesnt use an index. The "text" datatype is present, but is a BLOB subtype (as usually in C world - it's not a text, it's "null-terminated string"). I don't think you'd do badly using either but I'd lean towards postgresql. It seems to be deveoping at a faster rate than Interbase and probably has the edge performance wise. While Postgres has better future, IB is better now. IB has long way away as a commercial product, being utilized by most critical user (US Army used IB in it's M60TTS and M1 to M1IPM tanks). Anyway, i like IB. It's always the same - under Linux, Solaris, NT, NetWare... Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] InterBase
Od: "Sergey Larionov" [EMAIL PROTECTED] Temat: [PHP-DB] InterBase "Warning: InterBase: arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets in /home/larionov/public_html/base.php on line 6" How I can turn off tranliteration? You cann't just "turn it off" - this message means that client charset is different than db charset. If you have database created with default character set, say, WIN1252, you will get this message when you try to retrieve row using, say, WIN1250 and the row contains characters from outside of WIN1250 character set. This also happens when you do not specify character set when creating columns in tables then connect specifying character set - all characters above #127 will be trated as illegal and raise this error. That's why the best approach is to specify default character set when creating database - all character and text blob columns will use this character set and no special processing will be nacessary during connecting, just set the appropriate lc_ctype variable in database parameter buffer (i.e. in ibase_connect parameters). Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Interbase/PHP/Apache implimentation
Od: "Jordan" [EMAIL PROTECTED] Temat: [PHP-DB] Interbase/PHP/Apache implimentation So my question is this: Can DBMS support be enabled using the extension=php_interbase.dll directive in the php.ini file (as opposed to MySQL, where support is built in) ONLY while in CGI mode? Will the distribution version of php4apache.dll not look at the php.ini file, to enable Interbase support? If that is the case, is there anywhere one might find a version of the php4apache.dll file which enables Interbase support? I will use CGI if I must, but my preference is to use the Apache Module I have 2 installations: on NT4 at work and W98 at home, both working as a module. Except of OS the configuration is same: Apache 1.3.19, PHP 4.0.5, Borland's IB 6.0.1. If you are interested, i can send you my php.ini files privately, although this one from my work in tuesday. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Interbase BLOB Insertion Problem
Od: "Xanir" [EMAIL PROTECTED] Temat: [PHP-DB] Interbase BLOB Insertion Problem begin declare section; based on test.v1 document; based on test.v1.segment BlobV1Buffer; based on test.state CA; unsigned short BlobV1Len; end declare section; This is DSQL statement, you cann't use it in ISQL! For detailed description of IB BLOB hadling in PHP go to www.open-database.de Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle Database Class
Hi, try this: http://php.weblogs.com/ADODB Jarek Neil wrote: Hi All I want to build a site using classes and was wondering is there an Oracle Database class that I can use instead of writing one from scratch. I don't want to use abstraction layers. Can aynone direct me to a place where I can dowload such a class definition? Neil Craig QEDI (Pty) Ltd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Performance of Stored Procedures ?
Od: "Robert Boehrs" [EMAIL PROTECTED] Temat: [PHP-DB] Performance of Stored Procedures ? i've just made some simple test with oracle and stored procedures. I've used a simple select-statement within the stored procedure and the same query for a direct query within php. The direct query was about 50% faster. Is that normal? Will the stored procedures become faster with more complex queries? Most of performance benefit you will get when performing complex computations on data, such calculating taxes, rebates and other things. Selects are not too good examples. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] *.xls
HI, We are trying to do some functions to export data from database to Excel format. We have specyfication of the excel file format, and we are trying to generate binary file bite by bite, but we have problems with borders and frames. Maybe someone hes experienced similar problems? best regards Jarry Steve Brett wrote: i'd also be interested in this ... i have some code that will create .csv files for download, whihc is the way i normally do it. Steve -Original Message- From: Aivar Annamaa [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 13:02 To: [EMAIL PROTECTED] Subject: [PHP-DB] *.xls Hi Does anyone know some lib for generating excel files. I ask it here because database people could use such thing. Aivar Annamaa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Migrating from InterBase 4.0 to 6.0
Od: "Steve Farmer" [EMAIL PROTECTED] Temat: [PHP-DB] Migrating from InterBase 4.0 to 6.0 I need to migrate a database from InterBase 4.0 to 6.0 . Question is has anybody done this and what are the snafus !! The migration docs for 6.0 only seem to mention migration from 5.0 !! I would imagine a complete export from 4.0 and import into 6.0 would be the way to go. It is not directly "in topic"... There should be no problem with migration, if you have IB 4.0.2 - after restoring database in IB 6 you will get the same result. For specific IB help go to www.mers.com site or try asking at one of their newsgroups at news.mers.com Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] ? interbase ?
Od: "Bart A. Verbeek" [EMAIL PROTECTED] Temat: [PHP-DB] ? interbase ? 1. Can interbase be installed and run on every Unix-type (BSD)? I've taken a look on the borland site but they only speak of Linux and windows. Official Borland builds run only on Win32 and Linux. There are several other platforms supported by Firebird Project (firebird.sourceforge.net). 3. Is it possible to run MySQL and Interbase on the same server? Yes, they use different ports (MySQL 3360, IB 3050). 5. Does PHP have the same capabilities for Interbase as for MySQL? Bit less, but Interbase has bit more capabilities than MySQL. 6. How difficult is it to install a binary (not found on Borland site) or to compile it from source for a BSD-server? You can find binaries at firebird.sourceforge.net and www.ibphoenix.com. 9. Why would anyone choose Interbase when they can use MySQL on the same server? IB is best used when you don't want separate data accessible from www and your corporate data or your site data will be often updated concurrently by many users. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Re: PostgreSQL versus MySQL
Od: "Bob Hall" [EMAIL PROTECTED] Temat: Re: [PHP-DB] Re: PostgreSQL versus MySQL The implication is that MySQL is not an RDBMS. The only attempt I know of to define an RDBMS was Codd's, and no DBMS has ever met the criteria he published in a paper in the late 80s (1986?). Even though Oracle doesn't meet the criteria of the best known definition (only definition?) of an RDBMS, we all seem to agree that Oracle is an RDBMS. An RDBMS is a DBMS designed to manage a relational database, and a database is relational because it stores data in linked, normalized tables. The only thing I question in this is that without transaction support, what exactly is MySQL "managing"? The data in the normalized tables. Of 12 Codd's rules (1985), MySQL doesn't meet four: 5 - full internal language implementation with transactional processing support; 6 - using views for data modification; 10 - autonomous referential integrity mechanism built into database; 11 - autonomous data distribution. Of SQL-92 instructions MySQL doesn't implement following: CREATE | DROP SCHEMA, DECLARE LOCAL TEMPORARY TABLE, CREATE | ALTER | DROP DOMAIN, CREATE | DROP CHARACTER SET, CREATE | DROP COLLATION, CREATE | DROP TRANSLATION, CREATE | DROP VIEW, ALLOCATE | DECLARE | OPEN | CLOSE CURSOR, COMMIT, ROLLBACK, FETCH, CLOSE, CREATE | DROP ASSERTION, SET CONSTRAINTS MODE, SET SESSION AUTHORIZATION, SET TRANSACTION MODE, SET NAMES, SET SCHEMA, SET TIME ZONE, ALLOCATE | SET | GET | DEALLOCATE DESCRIPTOR, DESCRIBE, PREPARE, DEALLOCATE PREPARE, EXECUTE, EXECUTE IMMEDIATE, GET DIAGNOSTICS This set is about 85% of SQL-92 standart, but i didn't see any DBMS that implements that all. Of SQL-92 keywords, about 65% is absent in MySQL, but they are not too often used even if they are present with significant exception of trigger and procedural language. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Oracle functions and procedures via OCIParse and OCIExecute
Hi! I wonder if you have had the same problems with invoking oracle functions and procedures via OCIParse, OCIExecute functions? When I am trying to invoke a function or execute a procedure I receive an OCIStmtExecute error. The same statements works perfrectly direct in sqlplus. It't waird! Jarek -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Problem with IB's LEN
I have in my Interbase6 table a column defined as NUMERIC(18,2), but PHP shows it as integer value. During tests i discovered, that largest precision allowed for large exact numeric is 9 (NUMERIC(9,2)). Is there any switch that allows use larger precisions? Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Problems with character sets
Od: "magor" [EMAIL PROTECTED] Temat: [PHP-DB] Problems with character sets Hello everybody, I have problems concerning character sets.I use InterBase database. I have data in columns with character set NONE, but the data is in fact in win1250 coding. I have other columns with character set WIN1250. I want to from these NONE columns to these WIN1250 columns, but InterBase does not let me. There's only one thing you can do without moving whole data to new - properly defined - database. Try to change RDB$CHARACTER_SET_ID in RDB$RELATION_FIELDS, but first do a backup - it's a system table... Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Interbase and PHP support.
Od: "Mike" [EMAIL PROTECTED] Temat: Re: [PHP-DB] Interbase and PHP support. The BLOB functionality in the PHP interface is unstable. The process running the blob function crashes when trying to insert a blob ID into a table. That is a pretty large flakiness. There was one quite critical bug related to this that I fixed on July 9th and it appeared in 4.0.2. If you are using that version, please file a bug report with an example. BLOB functionality in this module isn't well tested, and without some help/testing from users, could remain flaky forever. I think that it has been finally adressed in 4.04 with php_ibase.dll version 1.48 - i had similar problems. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
