| Subject | Re: How can I enter a BLOB SUB_TYPE TEXT of more than 32K |
|---|---|
| Author | Adam |
| Post date | 2006-06-16T00:22:11Z |
--- In firebird-support@yahoogroups.com, "Jean-Louis Dehoux"
<jeanlouisdehoux@...> wrote:
varchar that can be defined, so my guess is that there is some internal
casting to handle it. How you do this depends on what language and
components you are connecting with.
The maximum size of a query is 64K, so even if you were to overcome
whatever the 32K problem is, there is another brick wall just around
the corner, so paramatised is the way to go.
Does the server actually crash (panic, shutdown and restart), or is it
just the that query fails ?
Adam
<jeanlouisdehoux@...> wrote:
>You may need to use a paramatised query to do that. 32K is the longest
> I created a test database with 1 table and 2 columns:
> CREATE TABLE Test(ID INTEGER, TestBlob BLOB SUB_TYPE TEXT)
> I can insert records into it as long as my testblob is shorter than
> 30000 characters.
> INSERT INTO TEST (ID, TestBlob) VALUES (1, '<long string>')
> If the string is greater than that, the server seems to crash.
> What am I doing wrong?
>
> Jean-Louis
>
varchar that can be defined, so my guess is that there is some internal
casting to handle it. How you do this depends on what language and
components you are connecting with.
The maximum size of a query is 64K, so even if you were to overcome
whatever the 32K problem is, there is another brick wall just around
the corner, so paramatised is the way to go.
Does the server actually crash (panic, shutdown and restart), or is it
just the that query fails ?
Adam