Disallowed implicit conversion from data type varchar to data type binary

Disallowed implicit conversion from data type varchar to data type binary, table name....

The above error message will be popped up while trying to store the binary object into a varchar column. For example,

CREATE TABLE mytest (ImageName varchar(100), ImagePath varchar(500))

In the above created table, If we try to push the image it will throw an error in converting the datatype. Because, the above wont do implicit conversion. The column type should be image datatype.

CREATE TABLE mytest (ImageName varchar(100), ImagePath image null)

Cheers,
Venkatesan Prabu .J