| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
SQL.InternalSQLiteLibrary.SetBase64ExtensionEnabled
Whether to enable the Base64 extensions.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| SQL | 15.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "SQL.InternalSQLiteLibrary.SetBase64ExtensionEnabled"; Value ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| Value | The new setting. Pass 1 to enable or 0 to disable. |
1 |
Result
Returns OK or error.
Description
Whether to enable the Base64 extensions.This is a SQLite extension for converting in either direction between a (binary) blob and base64 text. Base64 can transit a sane USASCII channel unmolested. It also plays nicely in CSV or written as TCL brace-enclosed literals or SQL string literals, and can be used unmodified in XML-like documents.
This is an independent implementation of conversions specified in RFC 4648, done on the above date by the author (Larry Brasfield) who thereby has the right to put this into the public domain.
The conversions meet RFC 4648 requirements, provided that this C source specifies that line-feeds are included in the encoded data to limit visible line lengths to 72 characters and to terminate any encoded blob having non-zero length.
Length limitations are not imposed except that the runtime SQLite string or blob length limits are respected. Otherwise, any length binary sequence can be represented and recovered. Generated base64 sequences, with their line-feeds included, can be concatenated; the result converted back to binary will be the concatenation of the represented binary sequences.
This SQLite3 extension creates a function, base64(x), which either: converts text x containing base64 to a returned blob; or converts a blob x to returned text containing base64. An error will be thrown for other input argument types.
Examples
Enable feature:
Set Variable [$r; Value: MBS( "SQL.InternalSQLiteLibrary.SetBase64ExtensionEnabled"; 1 )]
See also
- SQL.InternalSQLiteLibrary.Activate
- SQL.InternalSQLiteLibrary.GetBase64ExtensionEnabled
- SQL.InternalSQLiteLibrary.GetCSVExtensionEnabled
- SQL.InternalSQLiteLibrary.GetUUIDExtensionEnabled
- SQL.InternalSQLiteLibrary.SetCSVExtensionEnabled
- SQL.InternalSQLiteLibrary.SetUUIDExtensionEnabled
Release notes
- Version 15.3
Blog Entries
Created 2nd June 2025, last changed 29th June 2025
SQL.InternalSQLiteLibrary.LoadICU - SQL.InternalSQLiteLibrary.SetCSVExtensionEnabled
