VEC_FromText

Convert text to vector. This function parses a JSON array string representation of a vector and converts it into the binary VECTOR data type.

WEBINAR

The Next Generation of MariaDB: Powered by Vector Search

Watch Now

Vectors are available from MariaDB 11.7.

Syntax

VEC_FromText(s)

Description

VEC_FromText converts a text representation of the vector (json array of numbers) to a vector (little-endian IEEE float sequence of bytes, 4 bytes per float).

Example

SELECT HEX(vec_fromtext('[1,2,3]')); 
+------------------------------+
| HEX(vec_fromtext('[1,2,3]')) |
+------------------------------+
| 0000803F0000004000004040     |
+------------------------------+

_{This page is licensed: CC BY-SA / Gnu FDL}