Topic on Project:Support desk

Jump to navigation Jump to search

MS SQL problem with varbinary default '' in l10n_cache

Rocketpipe (talkcontribs)

The creation and insert on l10n-cache do not seem to work for MS SQL. I can fix the creation by removing the default. But for the insert, it seems that isbinary is not set fot he lc_value term, which needs to be modified. Has anyone else been successful at installing on a recent version of MS SQL? Do you do anything special for this table?

Rocketpipe (talkcontribs)

sorry, i should have added that i tried both 1.29.2 and 1.30

Ciencia Al Poder (talkcontribs)

I guess it should be "varbinary default (0x)" on SQLServer. It has been also reported on phabricator, task T192965. Note that SQL Server support for MediaWiki is poor and not recommended.

Rocketpipe (talkcontribs)

I went to look at that and your comment on it. I signed up for phab and copied this comment there.

The core problem is the implicit conversion from varchar to varbinary is indeterminate as it is not known if the intention is to convert to 8 bit character codes, or to 16 bit Unicode. I am unclear why the base type is varbinary as the core problem of whether Unicode is the default coding does not seem to be resolved. It is true that removing or changing the default allows the install to continue, but does not allow setup to complete, so it really does not fix the problem.

There seems to be a related problem that isbinary is not being set for this column which seems to be a clear error.

I have tested 1.29.2 and 1.30 fail and 1.27. LTS succeeds. Has anyone been able to make 1,29+ work with MS Sql?

Reply to "MS SQL problem with varbinary default '' in l10n_cache"