[development] FW: [Drupal bug] fix text:big, add CLOB, update BLOB handling

[Edison Wong]

May someone help me? I need some advice about this patch :)

Issue status update for
http://drupal.org/node/147947
Post a follow up:
http://drupal.org/project/comments/add/147947

 Project:      Drupal
 Version:      6.x-dev
 Component:    database system
 Category:     bug reports
 Priority:     critical
 Assigned to:  hswong3i
 Reported by:  hswong3i
 Updated by:   hswong3i
 Status:       patch (code needs review)
 Attachment:   http://drupal.org/files/issues/drupal-6.x-dev-clob-0.4.diff
(46.2 KB)

this patch standardize drupal BLOB/CLOB handling for cross DB compatibility,
e.g. db_update_* for LOBs value update,
db_encode_*/db_decode_* for LOBs value encoding/decoding. change incude:

* new API: db_update_blob(), db_update_clob(), db_encode_clob(),
db_decode_clob()
* updated API: _db_query_callback(), db_encode_blob()
* module with BLOB change: cache
* modules with CLOB change: aggregator, block, comment, contact, node



for current stage, it is only a dummy mapping for "clob" type among
mysql/pgsql, where mapping it as like as that of "text" type. BTW, it will
greatly decrease the difficulty for other DB driver implementation, e.g.
oralce, mssql and db2.


this patch only change the handling for LOBs type. therefore, unless
developer choose to use BLOB/CLOB type, nothing will affect them. on the
other hand, if developer choose to use LOBs type, which means that they will
have (nearly) unlimited storage size, BTW trade off some query level
features, e.g. using GROUP BY, ORDER BY, WHERE, etc.




hswong3i