Hashing both numbers (123) and (167) gives the same hashed id about hashids HOT 12 CLOSED

We don't recommend to store the hashids in the database. Instead encode/decode them on the fly.

Use it when you don't want to expose your database numeric ids to users.

from hashids.

So the hashes are unique, and the behaviour is correct, the only issue is with your database being case insensitive.

from hashids.

Setting up a collation in the database may help you.
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
https://stackoverflow.com/a/6448861

from hashids.

If you think you've found a bug. Please provide a failing test case in the HashidsTest test class in a pull request.

from hashids.

Something similar happened to me!

Error reproduction
$hash = (new Hashids\Hashids('App\Models\Model'.'_string', 16))->encode(545) --> "KQAd7lo8XLogXG69"
$hash = (new Hashids\Hashids('App\Models\Model'.'_string', 16))->encode(501) --> "KQAd7lo8JLWgXG69"

from hashids.

@j8n as you can see, these are not the same hashes:

KQAd7lo8XLogXG69
KQAd7lo8JLWgXG69

from hashids.

Yes ok, I cannot reproduce the error again (with test data). I had a "Integrity constraint violation: 1062 Duplicate entry" for a hash id in a record

from hashids.

Ok, just to share the original as in my production env:

$hash = (new Hashids\Hashids('App\Models\Subscription'.'_OUTGO', 16))->encode(501); --> "P17zevgVkZExk80a"
$hash = (new Hashids\Hashids('App\Models\Subscription'.'_OUTGO', 16))->encode(545); --> "P17zevgVKZExk80a"
The only change is the case of the "K"

That's how I got the error above

from hashids.

The only change is the case of the "K"

This is the expected behaviour.

from hashids.

What's the use of Hashids lib, if we get a "Integrity constraint violation" error in the database? The database seems to understand the case incorrectly.
What do I have to do?

from hashids.

ok thanks

from hashids.

I'm saving the hashids to the DB and it is not possible to refactor the system, is there a way to make the DB queries in laravel to be case sensitive ?

from hashids.