Reference Citations - HerongYang.com - v2.95, by Herong Yang
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: https://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
Service Oriented Computing for Dynamic Virtual Learning Environments
Migrating files to new computer
mswsock.dll!WSPStartup +0x102b
edu.uiuc.ncsa.soap.SOAPUtil.java
Put icons on bookmarks sidebar folders
Blob Storage via REST from Java?
java.lang.OutOfMemoryError: unable to create new native thread
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
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
Using ASP.Net c# To add/edit/delete data (ms access)
A UML/SPT Model Analysis Methodology
Creation d'un nouvel utilisateur sous SQL Server 2000
No Suitable Driver connecting jdk1.5 with javaDB derby
Acessar MSAccess com Hibernate
SiLu – Riktlinjer för spelmotor
JDBC help needed; java.lang.NoClassDefFoundError
CSV export of tickets has wrong encoding