If I read your question right, the only difference is that one is case sensitive, and the other insensitive?
Implications are pretty obvious, if you're going from CS -> CI
CS 'a' and 'A' are different.
CI 'a' and 'A' are treated as equals.
You may run into uniqueness issues for one thing.
/Kenneth