iBase.ru Forum

Код: Выделить всё

SET SQL DIALECT 3;

CREATE DATABASE 'x.x.x.x:/var/interbase/stat2.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1251;

Код: Выделить всё

CREATE TABLE AGREEMENTS (
    AID INTEGER NOT NULL,
    CID INTEGER NOT NULL,
    ATYPE INTEGER NOT NULL,
    NUM VARCHAR (128) CHARACTER SET WIN1251 COLLATE WIN1251,
    SDATE DATE,
    EDATE DATE,
    OSID INTEGER NOT NULL,
    FIODIR VARCHAR (256) CHARACTER SET WIN1251 COLLATE WIN1251,
    DELETED INTEGER,
    COMMENT VARCHAR (256) CHARACTER SET WIN1251 COLLATE WIN1251);

Код: Выделить всё

	function connect( $user = '', $pass = '', $db = '' ,$charset = '',$buffers = 0, $dialect = 3){

    		$this->conn = ibase_connect($db, $user, $pass, $charset, $buffers, $dialect);

//    		$this->conn = ibase_connect($db, $user, $pass, $charset);
                      
                print ibase_errmsg();
		if ($this->conn){
	           ibase_timefmt('%d.%m.%Y %H:%M:%S');
	           ibase_timefmt('%H:%M:%S',IBASE_TIME);
  	           ibase_timefmt('%d.%m.%Y',IBASE_DATE);
		}
		return $this->conn;
	}