Click here to Skip to main content
15,867,686 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi all,

m new to sql conversion ,

i want to convert
SQL
convert nvarchar to image sql server 2008



thanks in advance
Posted
Updated 20-Jan-16 23:00pm
v2

C#
using (MemoryStream ms = new MemoryStream(nvarchar, 0, nvarchar.Length))
       {
           ms.Write(nvarchar, 0, nvarchar.Length);
           newImage = System.Drawing.Image.FromStream(ms, true);
       }


try this code


C#
image is also binary bits in sql server. u dont need to convert
 
Share this answer
 
v2
Comments
Master Vinu 21-Jan-16 4:43am    
Beginner Luck

i wan to convert in sql 2008 view not in code
Beginner Luck 21-Jan-16 4:50am    
image is also binary bits. u dont need to convert
Master Vinu 21-Jan-16 4:51am    
when m try to get it on crystal it show me only name of image
Beginner Luck 21-Jan-16 4:54am    
crystal report??
Master Vinu 21-Jan-16 4:55am    
yes
C# Corner : store-and-retrieve-image-on-crystal-report-from-sql-database[^]


Do not know if is this what you really wanted ??
 
Share this answer
 
v3
Not sure why you would want to do it, but here is a way it can be done.

Only tested on MSSql server 2012 but it should work for 2008
note: text from google translate :) (correct accordingly)
SQL
declare @nvarchar nvarchar(max);
set @nvarchar = N'here is nvarchar text --- 這裡是nvarchar的文本 --- هنا هو النص nvarchar ---';
with nVarCharToImage as (
	select convert(image,
		convert(varbinary(max),@nvarchar)
	) nVarCharImage
)
, ImageTonVarchar as(
	select 
		convert(nvarchar(max),
			convert(varbinary(max),nVarCharImage)
		) ImgageTonVarChar from nVarCharToImage
)
select
(select nVarCharImage from nVarCharToImage) nVarCharImage,
(select ImgageTonVarChar from ImageTonVarchar) ImgageTonVarChar
;

If just converting varchar, you can do a direct varchar to image conversion:
SQL
declare @varchar varchar(max);
set @varchar = 'here is varchar text';

with VarCharToImage as (
	select convert(image, @varchar) VarCharImage
), ImageToVarchar as(
	select convert(varchar(max), convert(varbinary(max),VarCharImage)) ImgageToVarChar from VarCharToImage
)
select
(select VarCharImage from VarCharToImage) VarCharImage,
(select ImgageToVarChar from ImageToVarchar) ImgageToVarChar
;


Hope that helps you out.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900