Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

More support options:

Use the search page;

Email us at support@axioworks.com;

Send us a message using the Contact Us page.

Errors when using a case-sensitive collation for a SQList destination database

If you configure a destination database to use a case-sensitive collation (e.g. "Latin1_General_BIN") and are running SQList version ver. 6.1.1.0 or lower, you need to apply some manual fixes to the database by running the following T-SQL:

create view dbo.[(SQList.replicatedLists)] as
select * from [(SQList.ReplicatedLists)];
go

create view dbo.[(SQList.Changelog)]
as
select * from [(SQList.ChangeLog)];
go

alter table [(SQList.ChangeLog)] add [id] as ([ID]); go

create view [(SQlist.ChangeLogRelevantChangeItemEntries)]
as
select * from [(SQList.ChangeLogRelevantChangeItemEntries)];
go

For more details about collations, see these articles:

https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-helpcollations-transact-sql?view=sql-server-2017

Our use of cookies

Popular articles

More support options:

Errors when using a case-sensitive collation for a SQList destination database