MSSQL binary data

'Inserting BLOB Values with SQL INSERT Statements' tutorial was cited in a U++ Framework forum post in 2008.

The Inserting BLOB Values with SQL INSERT Statements tutorial was cited in a U++ Framework forum post in 2008.

Subject: MSSQL binary data
Date: 21 November 2008
Author: luzr
Source: http://www.ultimatepp.org/forum/index.php?t=msg&goto=22837&

>Well, I needed to store image files into MSSQL and found we have no
>real support there yet...
>
>I guess this should be addressed soon, anyway, for now, here is very
>simple function to workaround the insert/update (fetch seems to
>work):
>
>SqlVal MsSqlBinary(const String& data)
>{
> return SqlVal("convert(varbinary(max), '0x" + HexString(data)
> + "', 1)", SqlS::FN);
>}
...

Well, this simpler variant works too:

SqlVal MsSqlBinary(const String& data)
{
 return SqlVal("0x" + HexString(data), SqlS::HIGH);
}

Interestingly, it seems like similar method should work for Oracle 
and MySql as well:
http://www.herongyang.com/jdbc/Oracle-BLOB-SQL-INSERT.html

Something to add to SqlExp. So far, with Oracle, I was always using 
SqlRaw, but that means no SqlExp...

Table of Contents

 About This Book

 Reference Citations in 2016

 Reference Citations in 2015

 Reference Citations in 2014

 Reference Citations in 2013

 Reference Citations in 2012

 Reference Citations in 2011

 Reference Citations in 2010

 Reference Citations in 2009

Reference Citations in 2008

 QaTraq Pro API

 Service Oriented Computing for Dynamic Virtual Learning Environments

 Inverted ?

 Migrating files to new computer

 mswsock.dll!WSPStartup +0x102b

 edu.uiuc.ncsa.soap.SOAPUtil.java

MSSQL binary data

 Correct Character Encoding

 Put icons on bookmarks sidebar folders

 Blob Storage via REST from Java?

 java.lang.OutOfMemoryError: unable to create new native thread

 Obróbka filmów VOB

 ASP Search Function

 SSLHandshakeException unable to find valid certification...

 Using response.setContentType to switch HTML to Word

 Automatic Creation of Different Types of Test Subjects

 ISM 6121 Information Systems Implementation

 JVMSTAT[JSTAT]

 Time out bei Aufruf von WebService (php-Script)

 Store and retrieve Chinese characters using Coldfusion MX7 and MySQL5.0

 converting VCD player to DVD player

 tomcat中配置https

 αρχειο .pl

 Using ASP.Net c# To add/edit/delete data (ms access)

 regarding JDBC

 A UML/SPT Model Analysis Methodology

 Creation d'un nouvel utilisateur sous SQL Server 2000

 No Suitable Driver connecting jdk1.5 with javaDB derby

 Page in Chinese

 Acessar MSAccess com Hibernate

 SiLu – Riktlinjer för spelmotor

 [WebService] come fare?

 JDBC help needed; java.lang.NoClassDefFoundError

 CSV export of tickets has wrong encoding

 MapGuide Manual - Active selections

 Reference Citations in 2007

 Reference Citations in 2006

 Reference Citations in 2005

 Reference Citations in 2004

 Reference Citations in 2003

 PDF Printing Version