[TYPO3-core] FYI: bitwise & is not portable SQL

Martin Kutschker Martin.Kutschker at n0spam-blackbox.net
Wed Nov 8 18:16:23 CET 2006


Hi!

I've just seen a posting on the dev list. It seems the Core (or an 
extensions) uses a bitwise AND in an SQL statement. But that is not portable.

Oracle (and DB2?) don't have the & operator. Oracle has a BITAND(a,b) 
function instead (dunno about DB2). PosgreSQL has the & and I think MS SQL 
Server has it too.

So only Oracle here is the bummer...

Masi



More information about the TYPO3-team-core mailing list