[Phpgroupware-developers] compatibility between all databases

[address@hidden]

Hi!
I have a problem with sybase, and solving it properly may
impact the whole project, so tell me if it is better to
just hack the sybase port (and maybe some other db ports)
or make a huge change in phpgroupware.

Here is the error message I had on
phpgroupware/setup/setup_demo.php (install the demo accounts):
Warning: Sybase message: Implicit conversion from datatype
'VARCHAR' to 'INT' is not allowed. Use the CONVERT
function to run this query. (severity 16) in
/opt/alt/web/html/htdocs/phpgroupware/phpgwapi/inc/class.db_sybase.inc.php
on line 148
Database error: Invalid SQL: insert into phpgw_accounts
(account_lid, account_type, account_pwd,
account_firstname, account_lastname, account_status,
account_expires) values
('Default','g','438bf90a818801ad1fc0982c343ef11b',
'Default','Group','A','-1')


This message means that sybase is not able to convert a
string to a varchar.

Here are some ways to solve the problem:
- I put no varchars in the database. Only texts. That
makes an unoptimized use of the database. That impacts
only the sybase users.

- I use regexs to use the "convert" keyword. Before that,
I need to read the column types to check what I have to
convert. This is very dirty, should be slow for sybase
users, and I don't even know how much stable it would be.

- We all use a new php function, that would return the
argument with no change for mysql and pgsql but add some
stuff for sybase. That means to check all the files of
phpgroupware to update them.

So what do you think? Any other idea? Any hint for sybase
that my DBA could not give me here?

BTW, my work on porting phpgroupware to sybase is
progressing: I managed to install the applis!

Yves

--
homepage - http://ymettier.free.fr                   -
gtktalog - http://www.freesoftware.fsf.org/gtktalog  -
cardpics - http://www.freesoftware.fsf.org/cardpics/ -

--------------
Profitez de l'offre spéciale Tiscali Liberty Surf !
50% de temps en plus pendant 3 mois sur tous les forfaits Internet.

http://register.libertysurf.fr/subscribe_fr/signup.php3