Hello,
While waiting for comment response, ran some simple tests using Mint 18.3, LO v6.2.0.3 and MySQL connection. Only problem encountered was returned item was an object
. Cleared this problem by casting the to a Char field then worked OK.
Data entered without password:
SELECT cast(DES_DECRYPT(testField) AS CHAR(100)) AS "DeCrypted" FROM test;
Data entered with password:
SELECT cast(DES_DECRYPT(testField, 'XXXX') AS CHAR(100)) AS "DeCrypted" FROM test;
If you have Base connected to MySQL, then HSQLDB is not involved.
Your question doesn't seem clear. Are you using MySQL from Base or are you switching to HSQLDB? HSQLDB doesn't appear to have des_decrypt function.