Allow 255 character titles
lomoboy - October 24, 2006 - 18:32
| Project: | Drupal |
| Version: | 6.x-dev |
| Component: | node system |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
I have drupal based site which works under MySQL 4.0 (it's still mostly stable and fastest today and very popular at hosting providers) which don't works with utf. Thus my database is under cp1251. Each utf-8 character needs 2 character of cp1251 for the russian language. So it's only possible to hold node title with 64 character. It's to small. I have found previous issues - 1, 2, 3, and I haven't ideas why and who has closed their. I have increased title field in node and node_revision table to the 255 but I know that it's bad solution because I will have problems in the future with updating and redistribution of database.
#1
What is the encoding of your mysql table?
I'm moving this to a feature request to "allow 255 character titles" and therefore moved it to CVS. Also, the priority "critical" is reserved for things where your site is totally broken, so this issue should be priority "normal". At the moment the site works, but is limited in function.
#2
My DB is encoded with cp1251.
#3
I believe the point of one of those other issues was that if you use UTF8 then you can use up to 128 characters. Can you try that?
#4
I cannot try because there is no support of UTF on my hosting playground, also as I known there is no support of UTF-8 in MySQL 4.0. So, if you works under 4.0 which encoded by latin charset you haven't problems with field's length because 1 latin charset encoded by 1 sybmbol.
#5
I mean if use put UTF's english words in DB encoded by latin there is no problem. But if you put the same word in russian you will get the problem.
#6
#7
I'm not really into the technical stuff of databases and encoding, but I'm working on a site right now where I need 255-character titles. Can anyone explain why nothing was done with the feature request above? Are there performance reasons why setting the title column to varchar(255) is not a good idea? What are the risks if I just change the type of my title column to varchar(255)? (I guess there is the possibility that it will be set back to 128 on an upgrade?)
#8
OK, I found two things since I posted my previous message.
1) In D6, the maximum title length is 255 characters. I'm changing this one to fixed.
2) For D5, there is a module available at http://drupal.org/project/longer_titles which changes the maximum title length to 255.
#9
Automatically closed -- issue fixed for two weeks with no activity.