Unique comparison is case sensitive

[ivanvermeyen]

It seems that the where clause in the unique_translation rule is case sensitive.

laravel-unique-translation/src/UniqueTranslationValidator.php

Lines 161 to 164 in 1eb3d56

	protected function findTranslation($connection, $table, $column, $locale, $value)
	{
	return DB::connection($connection)->table($table)->where("{$column}->{$locale}", '=', $value);
	}

According to my Google searches, MySQL is supposed to be case insensitive when using a collation that ends in _ci (I'm using utf8mb4_unicode_ci). But that's not what my tests are saying...

Is anyone else having this issue?

[Tahiaji]

yep

[ivanvermeyen]

Fixed by #22

[ivanvermeyen]

Just for later reference: using a LIKE query seems to be case insensitive too and improves compatibility with other database types than MySQL.