INSERT values in VARBINARY(MAX) column

Question

I have a table with a VARBINARY(MAX) column and I've tried inserting values into this table but I can't.

The QUERY is:

INSERT INTO [I_RACEDB].[dbo].[tce_lineno]([lineNo] ,[testCaseName] ,[project])
 VALUES (<lineNo, varchar(250),> ,<testCaseName, varbinary(max),>,<project, varchar(100),>)

INSERT INTO [I_RACEDB].[dbo].[tce_lineno] ([lineNo],[testCaseName],[project])
     VALUES ('44','TestCase_TestCheck01_Mail_Validation','proj001')

The ERROR is:

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

How can I insert values?

Giorgi Nakeuri · Accepted Answer · 2015-02-03 07:25:07Z

7

The error is self explaining.

Use convert(VARBINARY(max), 'TestCase_TestCheck01_Mail_Validation')

I.e.:

INSERT INTO [I_RACEDB].[dbo].[tce_lineno] ([lineNo],[testCaseName],[project])
VALUES ('44',convert(VARBINARY(max), 'TestCase_TestCheck01_Mail_Validation'),'proj001')

edited Feb 3, 2015 at 7:25

answered Feb 3, 2015 at 7:14

Giorgi Nakeuri

35.9k8 gold badges50 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Damien_The_Unbeliever Over a year ago

And you now have the first 30 bytes of data in the table. You might want to specify a length on that varbinary

Collectives™ on Stack Overflow

INSERT values in VARBINARY(MAX) column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related