[dev] [cvs] commit: framework/VFS/VFS Object.php ftp.php sql.php sql_file.php

Matt Selsky selsky at columbia.edu
Thu Sep 22 00:25:23 PDT 2005


Should the SQL driver be using OCTET_LENGTH() instead of LENGTH()?  
Along with database specific options?  Also, would it useful to put this 
type of thing in the Horde_SQL class?

How to determine "length" in some popular databases:

MySQL: OCTET_LENGTH and LENGTH are the same.

PostgreSQL: LENGTH is for character data; OCTET_LENGTH is for binary 
data.

Oracle: LENGTH is for character data; OCTET_LENGTH is for binary data, 
but LENGTHB should be used instead.

MS-SQL: LEN is for character data; DATALENGTH is for any expression


-- 
Matt

On Wed, Sep 21, 2005 at 11:03:23PM -0700, Michael M Slusarz wrote:
> slusarz     2005-09-21 23:03:23 PDT
> 
>   Modified files:
>     VFS/VFS              Object.php ftp.php sql.php sql_file.php 
>   Log:
>   Bug: 162
>   The remaining vfs quota implementation.
>   
>   Revision  Changes    Path
>   1.19      +17 -1     framework/VFS/VFS/Object.php
>   1.90      +2 -2      framework/VFS/VFS/ftp.php
>   1.104     +78 -1     framework/VFS/VFS/sql.php
>   1.59      +34 -1     framework/VFS/VFS/sql_file.php
> 
>   Chora Links:
>   http://cvs.horde.org/diff.php/framework/VFS/VFS/Object.php?r1=1.18&r2=1.19&ty=u
>   http://cvs.horde.org/diff.php/framework/VFS/VFS/ftp.php?r1=1.89&r2=1.90&ty=u
>   http://cvs.horde.org/diff.php/framework/VFS/VFS/sql.php?r1=1.103&r2=1.104&ty=u
>   http://cvs.horde.org/diff.php/framework/VFS/VFS/sql_file.php?r1=1.58&r2=1.59&ty=u
> 
> -- 
> To unsubscribe, mail: cvs-unsubscribe at lists.horde.org


More information about the dev mailing list