Generate QR codes using Invantive UniversalSQL

Wiki (en)
1

Using Invantive UniversalSQL on selected platforms including Windows it is possible to generate images with QR codes directly from SQL.

There are two variants available:

  • barcode_qr: generate a QR-code with predefined dimenions and a text. Optionally the preferred version and error correction level can be specified.
  • barcode_qr_epc: generate a QR-code for use in payment application, according to the format specified by the European Payment Council.

barcode_qr

The SQL-function barcode_qr takes the following parameters:

  • width,
  • height,
  • text,
  • preferred version (optional),
  • error correction level (optional).

A sample is the following query:

select barcode_qr
       ( 400
       , 400
       , 'this is a text'
       ) qr

with result:

image

barcode_qr_epc

The SQL-function barcode_qr_epc takes the following parameters:

  • width,
  • height,
  • currency code,
  • amount,
  • recipient name,
  • recipient BIC,
  • recipient IBAN,
  • purpose code,
  • reference (unstructured),
  • information (unstructured).

A sample is the following query:

select barcode_qr_epc
       ( 500
       , 500
       , 'EUR'
       , 25.37
       , 'Invantive B.V.'
       , 'BUNQNL2A'
       , 'NL25BUNQ2098258607'
       , 'GDSV'
       , 'Factuur 314232323'
       , 'Informatie'
       ) iban

with result:

image

Availability

SQL-functions for QR codes are available in all products on release 24.0.192 and later.