Odp: [PHP-DB] InterBase

2001-07-29 Thread Jarek Zgoda

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

2001-07-13 Thread Jarek Zgoda

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

2001-05-22 Thread Jarek Zgoda

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]




Odp: [PHP-DB] ? interbase ?

2001-04-22 Thread Jarek Zgoda

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] Interbase and PHP support.

2001-01-22 Thread Jarek Zgoda

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]