Cannot insert with leading zero

[selfclose]

i'm use regular insert

db.get_connection(function (sql) {
    sql.insert('table', {phone: '012345678', function (err, res) {
    }
}

By the way builder cut first zero out

• This record is varchar
• I tried to .toSring() not working

when I check sql.last_query() it became number type 12345678 How to fix it

[kylefarris]

It does seem that there is some code in the library that will detect an all-numeric string and convert it to an integer. I'll see if I can create a quick patch for that that.

[kylefarris]

Fixed in v1.1.0