What does 'show table files;' give you? You might have the wrong type
of blob/text.
http://dev.mysql.com/doc/refman/5.0/en/blob.html
Below is ad-hoc commentary...
On Thu, Jan 8, 2009 at 11:02 PM, Christopher Jones wrote:
>
> I'm having issues inserting files into a BLOB field in MySQL, using so
On 8 Jan 2009, at 23:02, Christopher Jones wrote:
I'm having issues inserting files into a BLOB field in MySQL, using
something similar to this;
[...]
The problem is that files bigger than 64K are being truncated on
their insert into the database (i.e. the maximum BLOB length in the
databas
On Thu, Jan 8, 2009 at 5:00 PM, Kake L Pugh wrote:
> On Tue 06 Jan 2009, Kake L Pugh wrote:
>> Hello! The January social of the London Perlmongers is this Thursday,
>> 8th January. We're going to the Antelope, 22 Eaton Terrace, SW1W 8EZ.
>>
>> Note that we don't have a room booked this month, s
I'm having issues inserting files into a BLOB field in MySQL, using
something similar to this;
binmode($filehandle);
my $file_str;
{
local( $/, undef ) ;
$file_str = <$filehandle>;
}
my $statement = "
INSERT INTO 'files' (file_name, file)
VALUES (?,?,?)
";
my $sth = $dbh->prepare($stat
On Tue 06 Jan 2009, Kake L Pugh wrote:
> Hello! The January social of the London Perlmongers is this Thursday,
> 8th January. We're going to the Antelope, 22 Eaton Terrace, SW1W 8EZ.
>
> Note that we don't have a room booked this month, so we'll be wherever
> in the pub we find space. No doubt
On Thu, 8 Jan 2009, James Laver wrote:
On 2009-01-07 13:49, "James Laver" wrote:
Lets go to the counting house for a pie lunch tomorrow.
http://london.randomness.org.uk/wiki.cgi?Counting_House,_EC3V_3PD
Counting House
50 Cornhill
EC3V 3PD
Streetmap: http://streetmap.co.uk/newmap.srf?x=5329
On 2009-01-07 13:49, "James Laver" wrote:
>
> Lets go to the counting house for a pie lunch tomorrow.
>
> http://london.randomness.org.uk/wiki.cgi?Counting_House,_EC3V_3PD
>
> Counting House
> 50 Cornhill
> EC3V 3PD
>
> Streetmap: http://streetmap.co.uk/newmap.srf?x=532983&y=181101
> GooMap: