Trim missing

lock
push_pin
done
Answered
3

Trying to install Onsite 11.10, but get this error:

SqlException: 'TRIM' is not a recognized built-in function name.
Installation failed

Even if I set minor version to 13 (should be Sql 13, compability level 130) which does not have Trim() build in.

So what can I do?

27 Apr 2026 | 02:17 PM

All Replies (3)

Hi Martin, which version of MSSQL are you trying to install on?

27 Apr 2026 | 08:35 PM

It was MSSQL 2016, it should be minor version 13.
I installed a SQL 2022 and now it runs.

BUT some list values are in Rusian (I think). I live with it, if it is an error I am sure it will be fixed.

28 Apr 2026 | 08:36 AM

Ok, MSSQL 2016 does not have the TRIM function. It was added in MSSQL 2017.

According to this (https://docs.superoffice.com/en/onsite/compatibility/database.html) SuperOffice 11 has only been tested on MSSQL 2019 and MSSQL 2022.

28 Apr 2026 | 09:56 AM
Yes, I know trim is not there. But it should have worked with the minor version set to 13. But OK MSSQL2016 is old.
28 Apr 2026 | 09:58 AM

Add reply