Skip to content
Back

User ID case sensitivity

  • 0
  • Self Hosted
  • Auth
tluszczyk.
10 Mar, 2026, 14:04

I see that through REST (and SDK as well), getting a user is not case sensitive. And even though documentation does not clearly state that it is, the wording "Valid chars are a-z, A-Z, 0-9, period, hyphen, and underscore" kind of indicates that Anna and anna would be different IDs. I found an answer for this that this a DB feature, but is there a walkaround to make this possible? If not, then maybe it would be beneficial to add this information to the documentation

TL;DR
Developers are discussing user ID case sensitivity. The issue stems from how user IDs are stored in the database, as string comparisons are not case sensitive in Mariadb. Although REST and SDK currently do not support case sensitivity, developers suggest making an issue on Appwrite's Github to address this. A workaround is not available aside from modifying the database behavior. It is proposed that updating the documentation to clarify this information would be beneficial.
Kenny
10 Mar, 2026, 14:33

Not that this is the answer you want, but it looks like they're just doing _uid = id, and in mariadb string comparisons like this are not case sensative.

https://github.com/utopia-php/database/blob/main/src/Database/Adapter/SQL.php#L375C1-L378C57

But I agree, it should note that somewhere in the docs, ideally it should be case sensative though. You can make an issue for this in the appwrite github if you want.

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more