Question

SQL Collation Support

Laserfiche How To Installation and Upgrades

Updated November 30, 2022

asked on November 29, 2022

Hi All,

I can't find any documentation on SQL collation support anywhere.

Does Laserfiche support SQL Collation SQL_Latin1_General_CP1_CI_AS?

Cheers!

Chris Douglas

0 0

Answer

SELECTED ANSWER

replied on November 29, 2022

Yes, SQL collations are supported. I believe SQL_Latin1_General_CP1_CI_AS is the default SQL collation.

1 0

replied on November 30, 2022

Thanks Miruna!

0 0

Replies

replied on November 29, 2022

It would be helpful to know what your use case is here. Are we talking about custom queries in Workflow? Or is this for Lookup Rules in Forms?

My recommendation is to create custom views of your tables with all your complex fancy SQL Server SELECT query stuff in the View designer. Then point Laserfiche Forms/Workflow at your Views. That way you can customize the views to your heart's content, and it's the only way to go for Forms Lookup Rules.

0 0

replied on November 29, 2022

Sorry I should of been clearer. That’s what you get for rushing.

I’m specifically looking to confirm if the system databases support that collation. So repository, forms, workflow etc.

0 0

You are not allowed to follow up in this post.

Question

Question

SQL Collation Support

Answer

Replies

Sign in to reply to this post.