I tried to insert some binary data with Buffer objects, and when I fetched the data, it gave me the wrong result like:
To replicate:
awaitknex.schema.createTable("binary_data",(table)=>{table.binary("id",4)})awaitknex.table('binary_data').insert({id: Buffer.from([0xde,0xad,0xbe,0xef])})console.log(awaitthis.knex.select().from('binary_data'))// output: [{ id: 'ޭ��' }]I can replicate this when I connect to a remote database. Memory or file database works fine.
I tried to insert some binary data with
Bufferobjects, and when I fetched the data, it gave me the wrong result like:To replicate:
I can replicate this when I connect to a remote database. Memory or file database works fine.