1

Topic: binary string broke, business in the size 32? is not able? How to win?

There is a table (migration )

CREATE TABLE "__ MigrationHistory" (
"Model" BLOB SUB_TYPE 0 NOT NULL,
) ;

There is  the data a long line x ' 123123123'
Also the error the incorrect termination of a line and . nonsense, and both from application, and through IBExpert falls
Unique a guess why worked (~2 years) earlier, and now ceased - tables and columns became more and more
As a result the data size for this column simply quitted for 32  (previous already were 31xxx ) after adding of pair tables in the circuit
Any ideas in what a problem and that it is possible to make are necessary, considering that all sql is generated...

2

Re: binary string broke, business in the size 32? is not able? How to win?

Onax wrote:

any ideas in what a problem and that it is possible to make are necessary, considering that all sql
It is generated...

Yes, the size of a literal is restricted. No, with generated SQL anything it is impossible to make, it is necessary
To pass to the parametrized.

3

Re: binary string broke, business in the size 32? is not able? How to win?

Well to go nuts now.
Glory  that though source codes are opened, it turns out it is necessary  and  EntityFramework.Firebird.dll

4

Re: binary string broke, business in the size 32? is not able? How to win?

Onax wrote:

well to go nuts now.
Glory  that though source codes are opened, it turns out it is necessary  and  EntityFramework.Firebird.dll

And estimate that will be, when the counter for maxint passes... The whole world a brothel, all women... ... And the sun, , a lantern... One I Dartanjan all in the white.

5

Re: binary string broke, business in the size 32? is not able? How to win?

Old teddy bear;
640 KB of storage suffices any computer () much

6

Re: binary string broke, business in the size 32? is not able? How to win?

Dimitry Sibiryakov wrote:

it is passed...
Yes, the size of a literal is restricted. No, with generated SQL anything it is impossible to make, it is necessary
To pass to the parametrized.

Or to transfer 0 as length sql-stejtmenta in api (and to finish a line in zero): http://tracker.firebirdsql.org/browse/CORE-1117
And then it is possible> 64K. It is checked up.

7

Re: binary string broke, business in the size 32? is not able? How to win?

FastBaseDev;
Literals of lines for BLOB all the same 64K are restricted. And it only in FB> = 3.0

8

Re: binary string broke, business in the size 32? is not able? How to win?

Denis wrote:

literals of lines for BLOB all the same 64K are restricted.

Than it is convenient? After all even basis in a script not to preempt.

9

Re: binary string broke, business in the size 32? is not able? How to win?

FastBaseDev;
I told something about convenience? This architectural restriction which it is sensitive is lifted in 3.0 (I about literals).
The size  is lifted essentially.  - 10.

10

Re: binary string broke, business in the size 32? is not able? How to win?

About parameters I thought at once, here only is is specific in it is unique a place it is impossible to use parameters
The author of library was not mistaken, and easier not to push there them.
I fondly supposed that  I will make concat from small lines, but there was a total result too cannot get out for 32...