Problem with Blob type

Hi All !!!!!!!

I'm new in firebird, and i have a problem with blob type, I read for strings the blob type just accept 64k but i need store strings with more size.

how can I do that?

I'm programming in VB. NET.

Please help me.

Thanks a lot. yamazaki052

Where did you read that? See here for reference.

I was read this in other page, but i can't understand it.

Could you send me an example to declare a field for example if i need manipulate strings with 64 MB.

Thanks a lot. Yamazaki052

Declare it as BLOB, if your database has a pagesize of 1Kb your BLOB field will have a max size of 64Mb (this is by design).
AFAIK default pagesize should be 4Kb thus BLOB will be 4Gb, nowere I see the 64Kb you mentioned.

Here is an example of my probles, I'm trying to program a software to copy MS-JET Data Base (Access) to fireBird, in some fields, I store strings very very large, when this field is copy to my new data base my program crash.

I copy The string in a .txt file and the file size was 159 kb

o could you give me an example in VB.net code.

Thanks a lot for your help.

Yamazaki052

this is the form I declare this field

LEY_TEXTO BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE

I Use this in a SQL Order In VB. net to create the field.

Ok. I understand the problem.

Pabloj help me to understand the blob field, maybe the problem is not the field.

May be is the string variable in VB.net. all program run ok, just when I pass the string to blob field crash, Someone could help me please.

Thax in advance.

Yamazaki052

See this example