[DBAL-368] array and object types should use BLOB, not CLOB, to store serialized data Created: 19/Oct/12 Updated: 23/Jan/13 Resolved: 23/Jan/13 |
|
| Status: | Closed |
| Project: | Doctrine DBAL |
| Component/s: | None |
| Affects Version/s: | 2.2.2 |
| Fix Version/s: | None |
| Security Level: | All |
| Type: | Bug | Priority: | Major |
| Reporter: | Karsten Dambekalns | Assignee: | Benjamin Eberlei |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | postgresql | ||
| Description |
|
When using array or object types, PHP's serialize() is used. Since that can return NUL bytes, using a text type will fail at least on PostgreSQL (just search the web for issues of that kind…). So ArrayType and ObjectType should return a BLOB definition instead of a CLOB definition to be binary-safe. |
| Comments |
| Comment by Karsten Dambekalns [ 19/Oct/12 ] |
|
See DBAL-369 for the suggested fix |
| Comment by Marco Pivetta [ 23/Jan/13 ] |
|
Karsten Dambekalns |
| Comment by Marco Pivetta [ 23/Jan/13 ] |
|
Nvm, it was DBAL-369 |
| Comment by Marco Pivetta [ 23/Jan/13 ] |
|
Moved to DBAL-369 |