Sql query error on GetJobs about hangfire.tags HOT 11 CLOSED

It's ok. I have no rush. I'll create a PR. Review it when you have time. Btw, nice feature. Congrats!

from hangfire.tags.

Sorry for the late reaction to this, caught up in regular work. I've just pushed an update of the components.

About updating the Hangfire version: usually packages reference the lowest possible version to maintain compatibility with older projects. You're free to use a higher version though, it should give no problems whatsoever.

from hangfire.tags.

With what type of database? I’ve not seen this error before.

from hangfire.tags.

We try this on MS Sql Server.

from hangfire.tags.

SqlTagsServiceStorage.cs page line 104 and 205. Can you fix the lines and create new version please? We would like to use this nuget package. Besides, hangfire version is also a little bit old. May be you can update it either.

from hangfire.tags.

We use this on MSSql in production for a few years now. What is the database collation used? If that contains CS, can you change that to CI?

from hangfire.tags.

Our database collation is "Turkish_CI_AS", so im sorry but it is already case insensitive

from hangfire.tags.

I’ll try to create a reproduction of this issue, but am on holiday this week.

from hangfire.tags.

I’m a bit surprised though:

The way to determine if a database or database object is to check its "COLLATION" property and look for "CI" or "CS" in the result. The CI indicates that the server is case insensitive.

from hangfire.tags.

Since i'm not authorized, i cant create PR. :(

from hangfire.tags.

Hello,
Did you have chance to debug the issue?

from hangfire.tags.