title: Does Django use case sensitive filenames for FileField with MySQL backend?
body: <p>I'm using Django 3.1.3 and have a model with a FileField field. When I upload a file with same name, but different case, the logic I have is reporting that it is a duplicate. For example:</p>
  <pre><code>Files &lt;QuerySet ['92/565/20191222_152213.jpg', '92/565/cs_731__DSC8110.jpg', '92/565/ADs-2.MP4']&gt;, this 92/565/ADS-2.mp4
  </code></pre>
  <p>The logic is...</p>
  <pre><code>        other_pieces_in_room = Piece.objects.filter(room__id=self.room_id)
          other_files_in_room = other_pieces_in_room.values_list('file', flat=True)
          mylog.debug(&quot;Files {}, this {}&quot;.format(other_files_in_room, file.name))
          if file.name in other_files_in_room:
                  raise forms.ValidationError(&quot;...&quot;)
  </code></pre>
  <p>Model (relevant fields) is:</p>
  <pre><code>class Piece(models.Model):
      file = models.FileField(upload_to=media_location)
      room = models.ForeignKey(Room, on_delete=models.CASCADE)
  </code></pre>
  <p>Any thoughts as to what is going on?</p>