Can't insert value into sql. Data_Type is binary

Question

Query: $structure = DB::connection('sqlsrv')
    ->table('TB_USER')->insert([
    'sUserName' => 'testuser3',
    'nDepartmentIdn' => 15,
    'sTelNumber' => 59281292,
    'nStartDate' => 1482059457,
    'nEndDate' => 1945244457,
    'sEmail' => '[email protected]',
    'bal' => 0,
    'lm' => 0,
    'dlm' => 0,
    'lmdt' => '12/18/2016',
    'bPassword2' => 1234
]);

Error: SQLSTATE[HY000]: General error: 20018 Implicit conversion from data type varchar to binary is not allowed. Use the CONVERT function to run this query. [20018] (severity 16) [(null)] (SQL: insert into [TB_USER] ([sUserName], [nDepartmentIdn], [sTelNumber], [nStartDate], [nEndDate], [sEmail], [bal], [lm], [dlm], [lmdt], [bPassword2]) values (testuser3, 15, 59281292, 1482059457, 1945244457, [email protected], 0, 0, 0, 12/18/2016, 123456))

Alexey Mezenin · Accepted Answer · 2016-12-18 14:39:20Z

1

One of the columns has binary type, but you're trying to insert string. Set this column to varchar or convert value to binary to fix this.

edited Dec 18, 2016 at 14:39

answered Dec 18, 2016 at 14:32

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

2 Comments

Salikh Gurgenidze Over a year ago

Error is because bPassword2 column type is binary not boolean.

Alexey Mezenin Over a year ago

Oh yeah, it's binary. Well, you got the idea.

Collectives™ on Stack Overflow

Can't insert value into sql. Data_Type is binary

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related