Click here to Skip to main content
12,351,441 members (36,955 online)
   

Database

 
GeneralRe: Problem saving file to MySQL Pin
jrahma21-Jul-12 2:33
memberjrahma21-Jul-12 2:33 
GeneralRe: Problem saving file to MySQL Pin
Eddy Vluggen21-Jul-12 7:54
memberEddy Vluggen21-Jul-12 7:54 
GeneralRe: Problem saving file to MySQL Pin
jrahma21-Jul-12 8:40
memberjrahma21-Jul-12 8:40 
GeneralRe: Problem saving file to MySQL Pin
Eddy Vluggen21-Jul-12 9:21
memberEddy Vluggen21-Jul-12 9:21 
GeneralRe: Problem saving file to MySQL Pin
jrahma21-Jul-12 9:42
memberjrahma21-Jul-12 9:42 
GeneralRe: Problem saving file to MySQL Pin
jschell21-Jul-12 11:48
memberjschell21-Jul-12 11:48 
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 
GeneralRe: Making a row-based Iteration of a Bulk-Insertion Pin
Michael Potter19-Jul-12 3:50
memberMichael Potter19-Jul-12 3:50 
GeneralRe: Making a row-based Iteration of a Bulk-Insertion Pin
SkyRunner19-Jul-12 5:08
memberSkyRunner19-Jul-12 5:08 
QuestionSSIS and SSAS Pin
Member 927049917-Jul-12 21:06
memberMember 927049917-Jul-12 21:06 
AnswerRe: SSIS and SSAS Pin
Mycroft Holmes18-Jul-12 13:00
memberMycroft Holmes18-Jul-12 13:00 
QuestionRe: SSIS and SSAS Pin
Jan Steyn19-Jul-12 3:59
memberJan Steyn19-Jul-12 3:59 
QuestionMicrosoft reporting services Pin
berba17-Jul-12 0:44
memberberba17-Jul-12 0:44 
QuestionDeleting Data Using Job Scheduler Pin
ASPnoob16-Jul-12 22:59
memberASPnoob16-Jul-12 22:59 
AnswerRe: Deleting Data Using Job Scheduler Pin
rimazuc17-Jul-12 0:00
memberrimazuc17-Jul-12 0:00 
AnswerRe: Deleting Data Using Job Scheduler Pin
Michael Potter17-Jul-12 3:38
memberMichael Potter17-Jul-12 3:38 
QuestionAn Iteration with renaming and avoiding duplicates Pin
SkyRunner16-Jul-12 8:37
memberSkyRunner16-Jul-12 8:37 
QuestionRe: An Iteration with renaming and avoiding duplicates Pin
Suvabrata Roy16-Jul-12 8:55
memberSuvabrata Roy16-Jul-12 8:55 
AnswerRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 2:36
memberSkyRunner17-Jul-12 2:36 
AnswerRe: An Iteration with renaming and avoiding duplicates Pin
Mycroft Holmes16-Jul-12 12:58
memberMycroft Holmes16-Jul-12 12:58 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 2:39
memberSkyRunner17-Jul-12 2:39 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Mycroft Holmes17-Jul-12 2:59
memberMycroft Holmes17-Jul-12 2:59 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 3:08
memberSkyRunner17-Jul-12 3:08 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 3:44
memberSkyRunner17-Jul-12 3:44 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Michael Potter17-Jul-12 3:52
memberMichael Potter17-Jul-12 3:52 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 4:11
memberSkyRunner17-Jul-12 4:11 

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.160621.1 | Last Updated 24 Jun 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid