This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.

In this chapter, we'll describe the CLI locator functions: SQLGetLength, SQLGetPosition and SQLGetSubstring. These functions are used with locators of BLOBs and CLOBs. They are new in SQL3; as far as we know, no DBMS supports them. Our description is therefore fairly brief.