# Filter without being case sensitive

**URL:** <https://community.dreamfactory.com/t/filter-without-being-case-sensitive/3372>\
**Category:** REST API\
**Created:** [October 27, 2016, 12:43pm UTC](https://community.dreamfactory.com/t/filter-without-being-case-sensitive/3372 "2016-10-27T12:43:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![delebash](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@delebash](https://community.dreamfactory.com/u/delebash)\
**Post date:** [October 27, 2016, 12:43pm UTC](https://community.dreamfactory.com/t/filter-without-being-case-sensitive/3372/1 "2016-10-27T12:43:36Z")

</div>

Example filter:  
last\_name = zhu should return same results as last\_name = Zhu

---

<div class="post-metadata">

**Author:** ![DFCommunityManager](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/dfcommunitymanager/32/887_2.png) [@DFCommunityManager](https://community.dreamfactory.com/u/DFCommunityManager)\
**Post date:** [November 1, 2016, 7:03pm UTC](https://community.dreamfactory.com/t/filter-without-being-case-sensitive/3372/2 "2016-11-01T19:03:00Z")

</div>

Hey @delebash,

I’m a little confused on your question.

Can you provide more details of what you are trying to do and what you’re working on?

Any extra details would be appreciated.

Thanks,  
@AlexBowen

---

<div class="post-metadata">

**Author:** ![delebash](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@delebash](https://community.dreamfactory.com/u/delebash)\
**Post date:** [November 11, 2016, 2:13am UTC](https://community.dreamfactory.com/t/filter-without-being-case-sensitive/3372/3 "2016-11-11T02:13:22Z")

</div>

Example:  
In the live api docs select the db database  
Choose getDbRecords

table\_name: contact  
filter: last\_name = Yuan

Results are 2 records where last\_name = Yuan

If you have the same filter except this time last\_name is lower case  
filter: last\_name = yuan

Results are no matching records

So whether filter is lowercase or uppercase you get the same records returned

Is there value you can pass as a query parameter to disable case sensitivity when using filter?

---

<div class="post-metadata">

**Author:** ![mattschaer](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/mattschaer/32/914_2.png) [@mattschaer](https://community.dreamfactory.com/u/mattschaer)\
**Post date:** [November 11, 2016, 2:28am UTC](https://community.dreamfactory.com/t/filter-without-being-case-sensitive/3372/4 "2016-11-11T02:28:58Z")

</div>

@delebash what collation are you using in your database?

---

<div class="post-metadata">

**Author:** ![delebash](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@delebash](https://community.dreamfactory.com/u/delebash)\
**Post date:** [November 13, 2016, 1:38am UTC](https://community.dreamfactory.com/t/filter-without-being-case-sensitive/3372/5 "2016-11-13T01:38:13Z")

</div>

I see, for Sqlite it looks like you can change the collation at the connection level and table level. I am just using the built in db for quick testing and will probably be using Mysql, but is it possible to change the Sqlite collation in DF on the connection or database level?