# Secondary Index Case Sensitive

**URL:** https://discuss.aerospike.com/t/secondary-index-case-sensitive/1558
**Category:** Requests
**Tags:** secondary, index
**Created:** [July 31, 2015, 10:14am UTC](https://discuss.aerospike.com/t/secondary-index-case-sensitive/1558 "2015-07-31T10:14:16Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Fishdrowned](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/fishdrowned/32/299_2.png) [@Fishdrowned](https://discuss.aerospike.com/u/Fishdrowned)
#### Post date: [July 31, 2015, 10:14am UTC](https://discuss.aerospike.com/t/secondary-index-case-sensitive/1558/1 "2015-07-31T10:14:16Z")

</div>

I’m recently migrating our user data from MySQL to Aerospike, the user data contains username, email and other fields for login.

Now I get caught up in an index issue, I have to login with username in exactly case.

For example, I registered with username “Fishdrowned”, then I fail to login with “fishdrowned”

This make it unfriendly to the end user.

I’ve googled it and didn’t find any words about if Aerospike supports case-insensitive index or not.

Is it (case-insensitive index) supported in Aerospike, or is there any plan to support it in the future?

---

<div class="post-metadata">

### Author: ![wchu](https://avatars.discourse-cdn.com/v4/letter/w/a5b964/32.png) [@wchu](https://discuss.aerospike.com/u/wchu)
#### Post date: [July 31, 2015, 11:49am UTC](https://discuss.aerospike.com/t/secondary-index-case-sensitive/1558/2 "2015-07-31T11:49:29Z")

</div>

Aerospike secondary index does not support case processing. Case insensitivity can be taken care of by the application on insert and look up.

---

<div class="post-metadata">

### Author: ![Fishdrowned](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/fishdrowned/32/299_2.png) [@Fishdrowned](https://discuss.aerospike.com/u/Fishdrowned)
#### Post date: [July 31, 2015, 11:59am UTC](https://discuss.aerospike.com/t/secondary-index-case-sensitive/1558/3 "2015-07-31T11:59:19Z")

</div>

Yeah sure, application can do this, but it’s stupid.

Imagine that you need to add a new index to a set which already have millions or even billions records.
