Click here to Skip to main content
15,860,844 members
Home / Discussions / Database
   

Database

 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 4:58
jschell18-Apr-23 4:58 
AnswerRe: Choosing a proper database for mobile messenger app Pin
Eddy Vluggen17-Apr-23 23:27
professionalEddy Vluggen17-Apr-23 23:27 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 5:00
jschell18-Apr-23 5:00 
AnswerRe: Choosing a proper database for mobile messenger app Pin
Richard MacCutchan17-Apr-23 23:56
mveRichard MacCutchan17-Apr-23 23:56 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Code4Ever18-Apr-23 0:03
Code4Ever18-Apr-23 0:03 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Richard MacCutchan18-Apr-23 0:29
mveRichard MacCutchan18-Apr-23 0:29 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 5:15
jschell18-Apr-23 5:15 
QuestionHow do I retrieve the manipulated blob? Pin
lookilok4-Apr-23 21:09
lookilok4-Apr-23 21:09 
Through the this content
SQL Server - BLOB Import and Export[^]
and
How to store and fetch binary data into a file stream column[^]

, I was able to retrieve the blob from the FileImage column.
But it doesn't work for some records. In other words, it opens with an error for this type of file that has been fetched.

Table structure:
SQL
CREATE TABLE [dbo].[Attches](
[AttchID] [int] IDENTITY(1,1) NOT NULL,
[FileType] [varchar](30) NOT NULL,
[FileSize] [int] NULL,
[FileImage] [varbinary](max) NULL
)


I tried to extract a damaged document or pdf file in raw form and opened it with Hexinator software.
All the file that is corrupted, first its hex starts with the path of the file. In other words, it is manipulated.
Is there a way to retrieve data safely?
Best regards
AnswerRe: How do I retrieve the manipulated blob? Pin
jschell5-Apr-23 6:35
jschell5-Apr-23 6:35 
GeneralRe: How do I retrieve the manipulated blob? Pin
lookilok5-Apr-23 21:51
lookilok5-Apr-23 21:51 
GeneralRe: How do I retrieve the manipulated blob? Pin
jschell6-Apr-23 5:20
jschell6-Apr-23 5:20 
AnswerRe: How do I retrieve the manipulated blob? Pin
Richard MacCutchan6-Apr-23 6:08
mveRichard MacCutchan6-Apr-23 6:08 
QuestionTSQL, Order by case, and I need to order by version Pin
jkirkerx21-Mar-23 8:09
professionaljkirkerx21-Mar-23 8:09 
AnswerRe: TSQL, Order by case, and I need to order by version Pin
Ron Nicholson21-Mar-23 8:22
professionalRon Nicholson21-Mar-23 8:22 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx21-Mar-23 8:36
professionaljkirkerx21-Mar-23 8:36 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
Mycroft Holmes21-Mar-23 12:23
professionalMycroft Holmes21-Mar-23 12:23 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx21-Mar-23 13:17
professionaljkirkerx21-Mar-23 13:17 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jsc4222-Mar-23 0:17
professionaljsc4222-Mar-23 0:17 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx22-Mar-23 6:42
professionaljkirkerx22-Mar-23 6:42 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
jkirkerx21-Mar-23 8:46
professionaljkirkerx21-Mar-23 8:46 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
Ron Nicholson21-Mar-23 11:17
professionalRon Nicholson21-Mar-23 11:17 
AnswerRe: TSQL, Order by case, and I need to order by version Pin
jschell23-Mar-23 6:26
jschell23-Mar-23 6:26 
GeneralRe: TSQL, Order by case, and I need to order by version Pin
jkirkerx23-Mar-23 9:03
professionaljkirkerx23-Mar-23 9:03 
QuestionSQL where clause variability up against coding standards Pin
Brian L Hughes10-Mar-23 15:59
Brian L Hughes10-Mar-23 15:59 
AnswerRe: SQL where clause variability up against coding standards Pin
Dave Kreskowiak11-Mar-23 5:37
mveDave Kreskowiak11-Mar-23 5:37 

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.