BLOBs

Developers Databases
#1

Hi,

Good day!

How would I increase the max allowed packet size in mysql? I’ve been trying to upload some pdf files.

And just wondering, Is it possible to create a form in scriptcase in which one of the fields(read-only) is a BLOB column. Then when a user clicks that BLOB column (ex. pdf file) , it would open that particular file…

Thanks in advance…

#2

Re: BLOBs

Hello Ishey,

You can put a blob field on your form. Use the Scriptcase data type “Database (document)”.

Works very nice.

Regards,
Martin

#3

Re: BLOBs

In answer to your package size question. You can modify your mysql my.cnf :

key_buffer = 16M
max_allowed_packet = 16M

Modify to maximum wanted blob size.

After that restart mysql service (on Linux):
/etc/init.d/mysql restart

#4

Re: BLOBs

Hi mr2fit,

Thanks for replying, I really appreciate it…

I’m using XAMPP webserver, and now I’m trying to set the key_buffer and max_allowed_packet using command line since I can’t find the my.cnf…,

I’ve tried this:

mysql> set max_allowed_packet = 32000000;
Query Ok, O rows affected…

but then y it does not affect any changes… And I can’t find the my.cnf (xampp)

Thanks…
ishey

#5

Re: BLOBs

The my.cnf file is located in the mysqlin directory on xampp.
It may just show “my” as the name because Windows treats the .cnf as a very special file extension.

Try renaming it and opening it up in notepad.

This of course assumes you are using Windows version xampp.

Alan