Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
swdev:howto:work_with_blobs [2009/01/28 08:56] 127.0.0.1 external edit |
swdev:howto:work_with_blobs [2009/04/10 11:52] (current) smayr |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| == Working with BLOBs == | == Working with BLOBs == | ||
| + | === Creating Table with BLOB === | ||
| + | <code sql> | ||
| + | CREATE TABLE MyData ( | ||
| + | ID INTEGER NOT NULL, | ||
| + | RECDATE | ||
| + | PARAMVERSION | ||
| + | PARAMDATA | ||
| + | ); | ||
| + | </ | ||
| + | |||
| + | Blob subtypes definitions are: | ||
| + | 0 - binary data (such as image, video, audio, etc.). | ||
| + | 1 - text (standard text content). | ||
| + | 2 - BLR (used for definitions of Firebird procedures, triggers, etc.). | ||
| + | |||
| + | User applications should only use subtype 0 or 1. | ||