Click here to Skip to main content
12,944,121 members (53,227 online)
   

Database

 
GeneralRe: Problem saving file to MySQL Pin
jrahma21-Jul-12 11:57
memberjrahma21-Jul-12 11:57 
GeneralRe: Problem saving file to MySQL Pin
jschell22-Jul-12 6:56
memberjschell22-Jul-12 6:56 
AnswerRe: Problem saving file to MySQL Pin
Eddy Vluggen21-Jul-12 12:58
memberEddy Vluggen21-Jul-12 12:58 
GeneralRe: Problem saving file to MySQL Pin
jrahma22-Jul-12 8:39
memberjrahma22-Jul-12 8:39 
GeneralRe: Problem saving file to MySQL Pin
Eddy Vluggen22-Jul-12 10:24
memberEddy Vluggen22-Jul-12 10:24 
GeneralRe: Problem saving file to MySQL Pin
jrahma22-Jul-12 10:29
memberjrahma22-Jul-12 10:29 
GeneralRe: Problem saving file to MySQL Pin
Eddy Vluggen22-Jul-12 10:42
memberEddy Vluggen22-Jul-12 10:42 
GeneralRe: Problem saving file to MySQL Pin
Luc Pattyn22-Jul-12 10:43
mvpLuc Pattyn22-Jul-12 10:43 
1.
I don't recall ever having seen a Word document that would fit in 255 bytes.

I just created a Word document containing a single letter ("a"), saved it to disk, and found a file size of 29KB. That was Word 2007 BTW.

2.
The only type that is suited for storing binary data IMO is a "blob".
MySQL offers blob, and some size variants thereof. Use those. I never used "binary".

3.
Yes, saving and retrieving data to/from a database is tricky; as long as it doesn't work, it is hard to tell where the problem lies; it could be in the saving part, or in the retrieving part. And when you have several bugs at once (I'm sure you do!) fixing any one of them doesn't seem to help at all, until you get to the last one.

The good thing is, you have to solve it only once, as it would apply to any kind of data, as long as it fits a byte array model, it is all the same.

And the best thing is, millions of people have done this before, so the solution is bound to be available everywhere you look.

Smile | :)
Luc Pattyn [My Articles] Nil Volentibus Arduum

GeneralRe: Problem saving file to MySQL Pin
jrahma22-Jul-12 11:50
memberjrahma22-Jul-12 11:50 
AnswerRe: Problem saving file to MySQL Pin
Luc Pattyn22-Jul-12 11:57
mvpLuc Pattyn22-Jul-12 11:57 
GeneralRe: Problem saving file to MySQL Pin
jrahma22-Jul-12 12:18
memberjrahma22-Jul-12 12:18 
GeneralRe: Problem saving file to MySQL Pin
Eddy Vluggen22-Jul-12 23:59
memberEddy Vluggen22-Jul-12 23:59 
QuestionSQL server 2008 Replication problem Pin
Hy Chanhan19-Jul-12 17:12
memberHy Chanhan19-Jul-12 17:12 
AnswerRe: SQL server 2008 Replication problem Pin
_Amy19-Jul-12 21:31
member_Amy19-Jul-12 21:31 
GeneralRe: SQL server 2008 Replication problem Pin
Hy Chanhan19-Jul-12 21:38
memberHy Chanhan19-Jul-12 21:38 
GeneralRe: SQL server 2008 Replication problem Pin
_Amy19-Jul-12 22:34
member_Amy19-Jul-12 22:34 
Questionproblem modeling messages tables Pin
ahmadiss19-Jul-12 6:10
memberahmadiss19-Jul-12 6:10 
AnswerRe: problem modeling messages tables Pin
PIEBALDconsult19-Jul-12 12:24
memberPIEBALDconsult19-Jul-12 12:24 
GeneralRe: problem modeling messages tables Pin
ahmadiss20-Jul-12 0:44
memberahmadiss20-Jul-12 0:44 
GeneralRe: problem modeling messages tables Pin
PIEBALDconsult20-Jul-12 3:40
memberPIEBALDconsult20-Jul-12 3:40 
GeneralRe: problem modeling messages tables Pin
ahmadiss22-Jul-12 5:12
memberahmadiss22-Jul-12 5:12 
Questionhow to stop sql server 2005 Pin
sumeet kumar Attri18-Jul-12 21:38
membersumeet kumar Attri18-Jul-12 21:38 
AnswerRe: how to stop sql server 2005 Pin
Karthik Harve18-Jul-12 22:26
memberKarthik Harve18-Jul-12 22:26 
GeneralMaking a row-based Iteration of a Bulk-Insertion Pin
SkyRunner18-Jul-12 21:16
memberSkyRunner18-Jul-12 21:16 
AnswerRe: Making a row-based Iteration of a Bulk-Insertion Pin
Eddy Vluggen18-Jul-12 23:34
memberEddy Vluggen18-Jul-12 23:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170518.1 | Last Updated 23 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid