Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » MSSQL binary data
MSSQL binary data [message #19224] Fri, 21 November 2008 15:24 Go to previous message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
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);
}


Mirek

[Updated on: Fri, 21 November 2008 15:25]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: It is necessary BLOB field in MySQL
Next Topic: Possible SqlOption Problem [Solved]
Goto Forum:
  


Current Time: Sat Apr 27 16:48:27 CEST 2024

Total time taken to generate the page: 0.71153 seconds