mysql binary data in blob field

Thread View: borland.public.kylix.database.sqlservers

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Ulrich Fiege Fri, 01 Nov 2002 12:49

#127

Author: Ulrich Fiege
Date: Fri, 01 Nov 2002 12:49

19 lines
1483 bytes

Hi,

has anybody ever manged to store binary data in a blobfield in a mysql 
database with the SqlClientDataset ?

If yes, how ?

The only working way I found was to add a LOAD_FILE to the SQL 
statement, but to do this, the file must be on the server, which is not 
acceptable for me.

I tried to load the data  into the blobfield via file or stream, but 
this doesn't load binary data, it seems to handle only text data.

Any idea welcome, cause I am stucked with this.

Thanks in advance,

John

Re: mysql binary data in blob field

#129

Author: Ulrich Fiege
Date: Fri, 01 Nov 2002 20:45

14 lines
1312 bytes

Solved.

To make it short, everything worked fine the whole time, I did one big 
mistake.

I used an external app to check if the data was saved right, and the 
externall app is buggy.

I don't want to flame here about programs from other people, so I don't 
tell what proggie it was.



Bye

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads