UnityJDBC - Bit-wise Functions
Bit functions operate on 32-bit integers.
Summary
| Function | Syntax | Description |
|---|---|---|
| & | expr1 & expr2 | Bit-wise AND of expr1 and expr2. |
| BITAND | BITAND(expr1, expr2) | Bit-wise AND of expr1 and expr2. |
| BITOR | BITOR(expr1, expr2) | Bit-wise OR of expr1 and expr2. |
| BITXOR | BITXOR(expr1, expr2) | Bit-wise XOR of expr1 and expr2. |
| ^ | expr1 ^ expr2 | Bit-wise XOR of expr1 and expr2. |
| | | expr1 | expr2 | Bit-wise OR of expr1 and expr2. |
Detailed Function Descriptions
&
Syntax: expr1 & expr2
Bit-wise AND of expr1 and expr2. Equivalent to BITAND() function.
| SQL Server | Access | Oracle | PostgreSQL | MySQL | Sybase | HSQLDB |
|---|---|---|---|---|---|---|
 |  | | | | | |
BITAND
Syntax: BITAND(expr1, expr2)
Bit-wise AND of expr1 and expr2. Equivalent to & operator.
| SQL Server | Access | Oracle | PostgreSQL | MySQL | Sybase | HSQLDB |
|---|---|---|---|---|---|---|
| | | | | | |
BITOR
Syntax: BITOR(expr1, expr2)
Bit-wise OR of expr1 and expr2. Equivalent to | operator.
| SQL Server | Access | Oracle | PostgreSQL | MySQL | Sybase | HSQLDB |
|---|---|---|---|---|---|---|
| | | | | | |
BITXOR
Syntax: BITXOR(expr1, expr2)
Bit-wise XOR of expr1 and expr2. Equivalent to ^ operator.
| SQL Server | Access | Oracle | PostgreSQL | MySQL | Sybase | HSQLDB |
|---|---|---|---|---|---|---|
| | | | | | |
^
Syntax: expr1 ^ expr2
Bit-wise XOR of expr1 and expr2. Equivalent to BITXOR() function.
| SQL Server | Access | Oracle | PostgreSQL | MySQL | Sybase | HSQLDB |
|---|---|---|---|---|---|---|
| | | | | | |
|
Syntax: expr1 | expr2
Bit-wise OR of expr1 and expr2. Equivalent to BITOR() function.
| SQL Server | Access | Oracle | PostgreSQL | MySQL | Sybase | HSQLDB |
|---|---|---|---|---|---|---|
| | | | | | |