VEC_FromText

WEBINAR

The Next Generation of MariaDB: Powered by Vector Search

Watch Now

MariaDB starting with 11.6

Vectors were introduced in 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}