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.

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Title: Node title gets truncated to 64 character » Allow 255 character titles
Version: 4.7.4 » x.y.z
Category: bug » feature
Priority: Critical » Normal

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.

Anonymous’s picture

Anonymous (not verified) commented

My DB is encoded with cp1251.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented

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?

Anonymous’s picture

Anonymous (not verified) commented

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.

Anonymous’s picture

Anonymous (not verified) commented

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.

coreb’s picture

coreb commented
Version: x.y.z » 6.x-dev
marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
commented

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?)

marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
commented
Status: Active » Fixed

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.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.