# Function blob

- blob(): SQLiteBlobJsonBuilderInitial<"">

  It's recommended to use `text('...', { mode: 'json' })` instead of `blob` in JSON mode, because it supports JSON functions:

  > All JSON functions currently throw an error if any of their arguments are BLOBs because BLOBs are reserved for a future enhancement in which BLOBs will store the binary encoding for JSON.

  https://www.sqlite.org/json1.html

  #### Returns SQLiteBlobJsonBuilderInitial<"">

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:69
- blob<TMode extends BlobMode = BlobMode>(
  config?: BlobConfig<TMode>,
  ): Equal<TMode, "bigint"> extends true
  ? SQLiteBigIntBuilderInitial<"">
  : Equal<TMode, "buffer"> extends true
  ? SQLiteBlobBufferBuilderInitial<"">
  : SQLiteBlobJsonBuilderInitial<"">

  It's recommended to use `text('...', { mode: 'json' })` instead of `blob` in JSON mode, because it supports JSON functions:

  > All JSON functions currently throw an error if any of their arguments are BLOBs because BLOBs are reserved for a future enhancement in which BLOBs will store the binary encoding for JSON.

  https://www.sqlite.org/json1.html

  #### Type Parameters

  - TMode extends BlobMode = BlobMode

  #### Parameters

  - `Optional` config: BlobConfig<TMode>

  #### Returns Equal<TMode, "bigint"> extends true
  ? SQLiteBigIntBuilderInitial<"">
  : Equal<TMode, "buffer"> extends true
  ? SQLiteBlobBufferBuilderInitial<"">
  : SQLiteBlobJsonBuilderInitial<"">

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:70
- blob<TName extends string, TMode extends BlobMode = BlobMode>(
  name: TName,
  config?: BlobConfig<TMode>,
  ): Equal<TMode, "bigint"> extends true
  ? SQLiteBigIntBuilderInitial<TName>
  : Equal<TMode, "buffer"> extends true
  ? SQLiteBlobBufferBuilderInitial<TName>
  : SQLiteBlobJsonBuilderInitial<TName>

  It's recommended to use `text('...', { mode: 'json' })` instead of `blob` in JSON mode, because it supports JSON functions:

  > All JSON functions currently throw an error if any of their arguments are BLOBs because BLOBs are reserved for a future enhancement in which BLOBs will store the binary encoding for JSON.

  https://www.sqlite.org/json1.html

  #### Type Parameters

  - TName extends string
  - TMode extends BlobMode = BlobMode

  #### Parameters

  - name: TName
  - `Optional` config: BlobConfig<TMode>

  #### Returns Equal<TMode, "bigint"> extends true
  ? SQLiteBigIntBuilderInitial<TName>
  : Equal<TMode, "buffer"> extends true
  ? SQLiteBlobBufferBuilderInitial<TName>
  : SQLiteBlobJsonBuilderInitial<TName>

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:71