Re: Mssql and Mysql patches

Sander Wichers wrote: > > Hi, > > I don't know who applies patches, or who wants to? > But I added transaction support in the mysql & the mssql classes. (Almost > copy & paste from pgsql) and I added the affectedRows function to mssql. All hunks from both patches failed to be patched into the current CVS version. I don't have time to go hand-patching right now, could you send a diff against the CVS version? > I have a question/remark related to the tableinfo function: > Would it be possible to have a generic format types for all databases like : > (CHAR,BLOB,DATE... etc...) ? > Most PEAR supported databases support an sql statement to fetch tableinfo > from the db. > For example. (mssql): > select syscolumns.name,systypes.name,syscolumns.length from syscolumns > join systypes on systypes.xusertype=syscolumns.xusertype > join sysobjects on sysobjects.id=syscolumns.id > where sysobjects.name='$table' > > In that way we could have tableinfo for most databases. That's a good idea, Metabase has it and it seems to work well for them. - Stig