Re: [Phpgroupware-developers] compatibility between all databases

[Chris Weiss]

>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')

should that '-1' really be a string value?

address@hidden (address@hidden) wrote*:
>
>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
>
>
>--------------
>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
>
>
>
>
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>