Home » U++ Library support » U++ SQL » MSSQL binary data  
	
		
		
			| MSSQL binary data [message #19224] | 
			Fri, 21 November 2008 15:24   | 
		 
		
			
				
				
				  | 
					
						  
						mirek
						 Messages: 14271 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  
 |  
	| 
		
	 | 
 
 
 |  
  
 
Goto Forum:
 
 Current Time: Tue Nov 04 01:07:52 CET 2025 
 Total time taken to generate the page: 0.19328 seconds 
 |