---
name: "mysql_stmt_send_long_data"
section: "3"
platform: "linux"
package: "mariadb"
version: "13.0.2-2"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mysql_stmt_send_long_data"
---

# mysql\_stmt\_send\_long\_data(3)

### Name

mysql\_stmt\_send\_long\_data - Sends data in chunks

### Synopsis

-

  ```
  #include <mysql.h>
  my_bool mysql_stmt_send_long_data(MYSQL_STMT * stmt,
                                    unsigned int,
                                    const char * data,
                                    unsigned long);
  ```

### Description

Allows sending parameter data to the server in pieces (or chunks), e.g. if the size of a blob exceeds the size of max\_allowed\_packet size. This function can be called multiple times to send the parts of a character or binary data value for a column, which must be one of the `TEXT` or `BLOB` datatypes.

### Parameter

- •

  `stmt` - a statement handle, which was previously allocated by **[mysql\_stmt\_init(3)](/mysql_stmt_init/3.md)**.

- •

  `param_no` - indicates which parameter to associate the data with. Parameters are numbered beginning with 0.

- •

  `data` - a buffer containing the data to send.

- •

  `long` - size of the data buffer.

### Return value

Returns zero on success, nonzero if an error occurred.

### Notes

- •

  `mysql_stmt_send_long_data()` must be called before **[mysql\_stmt\_execute(3)](/mysql_stmt_execute/3.md)**.

- •

  bound variables for this column will be ignored when calling **[mysql\_stmt\_execute(3)](/mysql_stmt_execute/3.md)**.

### See also

- •

  **[mysql\_stmt\_execute(3)](/mysql_stmt_execute/3.md)**.