Jump to content

Existing user? Sign In
Sign In

Remember me Not recommended on shared computers

Forgot your password?
Sign Up

Browse
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
- More
Activity
- All Activity
- Search
- More
Join our Discord!
More
- More

MySQL Help

what field type is best for storing case sensitive values 32 characters long?

this.user

By this.user
November 22, 2010 in MySQL Help

Share

https://forums.phpfreaks.com/topic/219421-what-field-type-is-best-for-storing-case-sensitive-values-32-characters-long/

Recommended Posts

this.user

Member

this.user

Posted November 22, 2010

- Share

Posted November 22, 2010

what field type is best for storing case sensitive values 32 characters long?

for example i want to store: 43dfs23EFWsQtr

Quote

Link to comment

https://forums.phpfreaks.com/topic/219421-what-field-type-is-best-for-storing-case-sensitive-values-32-characters-long/

Share on other sites

Pikachu2000

Prolific Member

Pikachu2000

Posted November 22, 2010

- Share

Posted November 22, 2010

CHAR(32). Case-sensitivity depends on the collation. If it ends in _ci, such as utf8_unicode_ci, it's a case-insensitive collation.

Quote

Link to comment

https://forums.phpfreaks.com/topic/219421-what-field-type-is-best-for-storing-case-sensitive-values-32-characters-long/#findComment-1137780

Share on other sites

this.user

Member

this.user

Posted November 22, 2010

Author

- Share

Posted November 22, 2010

Fantastic! Thank you!

Quote

Link to comment

https://forums.phpfreaks.com/topic/219421-what-field-type-is-best-for-storing-case-sensitive-values-32-characters-long/#findComment-1137782

Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest

Reply to this topic...

× Pasted as rich text. Restore formatting

Only 75 emoji are allowed.

× Your link has been automatically embedded. Display as a link instead

× Your previous content has been restored. Clear editor

× You cannot paste images directly. Upload or insert images from URL.

Insert image from URL

×

Share

https://forums.phpfreaks.com/topic/219421-what-field-type-is-best-for-storing-case-sensitive-values-32-characters-long/

Go to topic listing

×

Browse
- Back
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
Activity
- Back
- All Activity
- Search
Join our Discord!

×

Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.