# Partitioning and case sensitivity

**URL:** <https://forums.percona.com/t/partitioning-and-case-sensitivity/20789>\
**Category:** Percona Distribution for MySQL\
**Created:** [March 20, 2023, 7:58pm UTC](https://forums.percona.com/t/partitioning-and-case-sensitivity/20789 "2023-03-20T19:58:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![egel](https://avatars.discourse-cdn.com/v4/letter/e/e36b37/32.png) [@egel](https://forums.percona.com/u/egel)\
**Post date:** [March 20, 2023, 7:58pm UTC](https://forums.percona.com/t/partitioning-and-case-sensitivity/20789/1 "2023-03-20T19:58:35Z")

</div>

Hey there.  
I am running: percona 5.7.26-29 on Centos.

It seems that when trying to match an row into range partition mySQL server ignoring string case.  
Perhaps we have partitioned table:  
create table partitioned\_table(  
pkey varchar(50)  
) PARTITION BY LIST COLUMNS(pkey)  
(partition p\_A values in (‘A’));

insert into partitioned\_table values (‘a’);  
insert into partitioned\_table values (‘A’);  
select \* from partitioned\_table partition(p\_a);  
±-----+  
| pkey |  
±-----+  
| a |  
| A |  
±-----+  
And obviously:  
insert into partitioned\_table values (‘b’);  
ERROR 1526 (HY000): Table has no partition for value from column\_list

It seems for me wrong are ‘A’ is not equal to ‘a’  
I didn’t find (probably didn’t looked good enough) in documentation any thing regarding this behaviour.

Any thoughts?  
Thanks

Update:  
Sorry my bad, I forgot that by default mySQL ignoring string case.  
Therefore a = A.  
So nothing to warry about, just remember…

---

<div class="post-metadata">

**Author:** ![egel](https://avatars.discourse-cdn.com/v4/letter/e/e36b37/32.png) [@egel](https://forums.percona.com/u/egel)\
**Post date:** [March 20, 2023, 8:03pm UTC](https://forums.percona.com/t/partitioning-and-case-sensitivity/20789/2 "2023-03-20T20:03:24Z")

</div>

Sorry my bad, I forgot that by default mySQL ignoring string case.  
Therefore a = A.  
So nothing to warry about, just remember…