Data Sync Does Not Support Pk's On String Types Using A Binary Or

[timhavens]

Is there a way to work around this WARNING?

Code:

…data sync does not support PK's on string types using a binary or case sensitive collation

I have a primary key which includes a column defined as utf8-bin in several key tables of a data base which I'm attempting to sync using 'sja'.

The column is required to be case-sensitive for my application.

[peterlaursen]

The best workaround I can think of is to ALTER TABLE 1) Make current Primary Key a UNIQUE INDEX instead 2) add an auto_increment INTEGER PK

You may also  use an older version for syncing this table (or the complete database or the complete job). However if you have values identical except for lettercase it may result in errors.  That is why we removed it.  Anyway if you want a copy we will find it for you (I think this was introduced in 7.0, but I have have to check)

[Author]

Posts