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. 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. Link to comment https://forums.phpfreaks.com/topic/137803-cant-change-collation-type/#findComment-721567 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.