natastna2 Posted July 30, 2010 Share Posted July 30, 2010 Hello. I'm having problems with my site as the search engine friendly URLS component can only take incoming URLS of less than 255 characters. Therefore, I simply want to change the Jos_sefurls orig_url column to say text as type rather than varchar. So I attempted just changing it and get: MySQL Error 1170: BLOB/TEXT Column Used in Key Specification Without a Key Length. So I did some research and ran DROP INDEX origurl ON jos_sefurls; which was a success. However, I still get the same message trying to change from Varchar to Text. Knowing very little about MySQL I could really do with some help. I'm sure the issue is very simple. Server version: 5.1.41 Quote Link to comment https://forums.phpfreaks.com/topic/209344-trying-to-change-varchar-to-text-please-help/ Share on other sites More sharing options...
Mchl Posted July 30, 2010 Share Posted July 30, 2010 In 5.1.x VARCHAR can hold up to 65,535 bytes. No need to move to TEXT. http://dev.mysql.com/doc/refman/5.1/en/char.html Quote Link to comment https://forums.phpfreaks.com/topic/209344-trying-to-change-varchar-to-text-please-help/#findComment-1093107 Share on other sites More sharing options...
natastna2 Posted July 30, 2010 Author Share Posted July 30, 2010 You are correct. I did try changing Varchar to a higher amount but got the same error previously so had not tried again. Now it works great thanks :-) One more quick question. Does the value/limit have any effect? As in is there any difference to putting the limit at 10,000 or 1,000. Does it affect the speed? Thanks a lot. Ant. Quote Link to comment https://forums.phpfreaks.com/topic/209344-trying-to-change-varchar-to-text-please-help/#findComment-1093148 Share on other sites More sharing options...
Mchl Posted July 30, 2010 Share Posted July 30, 2010 Yes it might affect the speed, and also how much data can be stored in other columns. Quote Link to comment https://forums.phpfreaks.com/topic/209344-trying-to-change-varchar-to-text-please-help/#findComment-1093168 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.