---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/binary.md
cuppy_section: docs
cuppy_doc: JTWA-9GC5
cuppy_doc_uuid: 75810e65-0c55-4117-9fcc-42642050d1e8
cuppy_permalink: https://cuppy.io/salesforce/d/JTWA-9GC5
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/binary
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 223bc3259fb3e0c735bc2a1fcf20453026fd5349a3c1b8e6bf1cd0fb466fefd2
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/binary.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

## Binary Data Type

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

The `bytes` data type allows the storage of binary strings.

A binary string is a sequence of octets (or bytes). Binary strings differ from character strings in two ways.

*   Binary strings can store octets of value zero and other non-printable octets.
*   Operations on binary strings process the actual bytes. Processing of character strings depends on locale settings.

Use binary strings to store raw byte data and use character strings to store text.

Data 360 SQL provides these aliases for the `bytes` type.

*   `bytea`
*   `blob`
*   `varbinary`

The input format is different from `bytes`, but the provided functions and operators are mostly the same.

The `bytes` type supports input and output by using the hex format.

The hex format encodes binary data as two hexadecimal digits per byte, the most significant nibble first. The sequence `\x` precedes the string. To escape the backslash character, use `\\x`. For input, the hexadecimal digits can be either upper or lower case.

Example:


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->