dmccabe Posted December 20, 2008 Share Posted December 20, 2008 I had a field in my table "REG" that was the primary key, However I discovered that was no good and that I need an "ID" field that had to be the primary key. So created the new field, made it the primary key and it's all good. However the old REG field has a collation type of "latin1_swedish_ci" and if try and change it so it has no collation type, it doesnt apply. It just goes back to having the "latin1_swedish_ci" collation. Anyone know why this may be? I only ask as I think it is impeding searches in another part of my script. Quote Link to comment https://forums.phpfreaks.com/topic/137803-cant-change-collation-type/ Share on other sites More sharing options...
fenway Posted December 22, 2008 Share Posted December 22, 2008 Every field has a collation... shouldn't make any difference on a numeric UID field. Quote Link to comment https://forums.phpfreaks.com/topic/137803-cant-change-collation-type/#findComment-721567 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.