U++ forum: Welcome to the forum

Re: MSSQL binary data [message #22812 is a reply to message #19274]

Tue, 18 August 2009 16:18

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

Can anybody make a simple example how to insert and select binary data from table?
I'm interesting in Oracle, Postgres and sqlite.
Sorry for my incopetence.
Thanks in advance.
Ion Lupascu.

Add:
I found that it can add as string in the folowing format:

INSERT INTO Image
 (ID, Subject, Body)
 VALUES (1, 'some subject'
, 'C9CBBBCCCEB9C8CABCCCCEB9C9CBBB') //Oracle format
//, 0xC9CBBBCCCEB9C8CABCCCCEB9C9CBBB) //SQL Server format
//, x'C9CBBBCCCEB9C8CABCCCCEB9C9CBBB') // MySQL format

WHERE C9CBBBCCCEB9C8CABCCCCEB9C9CBBB is binary data.

luzr wrote on Sun, 23 November 2008 23:28

captainc wrote on Sun, 23 November 2008 14:55

Those are good benefits. I'm interested, what kind of database do you use for binary data? What kind of settings do you set on the database? What is the schema like?

Ehm, usually I use DB per customer request.

Over time, I was storing binary data into Oracle, PGSQL and now in MSSQL. In fact, any single commercial app I have ever developed did it.

No special setting on DB. It should handle it just fine.

Nothing special about the schema either. It is just large binary column, that is all.

In fact, so far the only 'special' thing about large binary data in DB was the way of moving those data to DB - SqlRaw and no SqlExp.

Mirek

[Updated on: Tue, 18 August 2009 16:29]

Report message to a moderator