Changing a column collation
- by Stefan
Hey there,
I have a database already set up. I am trying to change the collation to case sensitive on my username column so it restricts login parameters to what they signed up with.
However I keep getting this: #1025 - Error on rename of './yebutno_ybn/#sql-76dc_8581dc' to './yebutno_ybn/user' (errno: 150)
there is foreign key constraints due to related tables....
any ideas? this will save me a lot of hassle with the php side of things!
Thanks,
Stefan