[BUG]: Blob column doesn't work with turso

[theodem]

What version of drizzle-orm are you using?

0.29.1

What version of drizzle-kit are you using?

No response

Describe the Bug

sqliteTable('table', { id: integer('id', { mode: 'number' }).primaryKey({ autoIncrement: true }), binary: blob('binary').notNull().type<ArrayBuffer>(), });

When i query the binary column, the typeof binary is a string which is the UTF8 encoded version of initial ArrayBuffer.

Using turso driver with libsql dev environment

Expected behavior

No response

Environment & setup

No response

[theodem]

This problem come from the environment where drizzle is running, in my case cloudflare workers which does not support Buffer.

Just tried in a classic node environment and it works ok.

Maybe we should implement a workaround to use ArrayBuffer in environnement that does not support Buffer ?

[theodem]

Closing it as it is working when using a polyfill to globalThis.Buffer

[dn-l]

@theodem I'd reopen the issue because it should be working without polyfill.