Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Implicit conversion from varchar to varbinary not allowed

Home
Forums

Implicit conversion from varchar to varbinary not allowed

Shahbaz Kaware

Shahbaz Kaware

9yAsked Mar 21, 2017, 4:06 AM4k

update TBL_PRODUCTDETAILS Set Picfront='System.Byte[]' where ID ='2147'

Msg 257, Level 16, State 3, Line 1

Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.

how to convert this query

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Amit Gupta9y ago
You might have to insert an image in your database. As you are passing byte class as a reference in your query from your frontend.

Either you have to pass the image byte in a proper way or convert it to base64 as already suggested by Nitin

You can google to find how to insert image to database
Nitin Sontakke9y ago
I am not 100% sure. But I think you will need to convert it to Base64String and store it.

You will need to try it yourself. Check if you can read it back and convert it to byte[] again.

Seet this : https://msdn.microsoft.com/en-us/library/dhx0d524(v=vs.110).aspx

Let me say this again. I HAVE NOT DONE IT.
Shahbaz Kaware9y ago
how can i update it can u plz explain
Nitin Sontakke9y ago
You cannot.

How can you have Set Picfront='System.Byte[]' in the query? It is going to put the STRING value 'System.Byte[]' in the column, not it's value.

You will need to convert it to (may be) Base64String and then update it.