How to increase length of forum title

[Gardarika]

So as the title say's... What and where should I edit?

[Lynne]

The two database fields, title and title_clean, in the forum table is set to 100 characters. So, if you want a longer title, you would need to actually modify the fields in the database.

Please make a database backup prior to doing any changes to your database.

[Christos Teriakis]

Originally Posted by Lynne

....is set to 100 characters. So, if you want a longer title, you would need to actually modify the fields in the database.

The problem is that for non-English sites operating in UTF-8 the limit is much less as there are letters getting even 4 symbols space.

[Lynne]

Originally Posted by Christos Teriakis

The problem is that for non-English sites operating in UTF-8 the limit is much less as there are letters getting even 4 symbols space.

Yep, I've run into that problem before which is why I remembered that it was a database limit, not some vbulletin limit, on the length of the title.

[Gardarika]

@ Lynne
I'd searched already in Internet and see the same problem, and to all that I have non-English forum. I completely forgot to mention about that.

And I got to know that datebase and forum should be in the same coding (language), I missed it completely.

Coding for datebase - itf8_general_ci for Russian is what I need or it's wrong?

[Christos Teriakis]

@Lynne: The problem is that such limits are oudated. Lenght limits are coming from the early database days when there was db space limits from Hosting providers especially for users of MS_SQL (Microsoft's tricks ). I believe that many users will remember those hosting plans: 100 MB webspace, 1 database max 10MB. I think that is good in a next update to have these values changed to varchar(255).

@Gardarika: If you're running a forum in Russian you're in worst position than Greeks. Without to be 100% sure, I believe that all Russian characters (Cyrillic alphabet) are getting 4 symbols. That means that in real you've not more than 40 characters available. My suggestion is to follow what Lynne wrote. It's not that difficult, but I don't know if there are other sections needing modification. eg search table??

Edited: In case that you'll see strange characters at the end of the title, it means that somewhere there is a restriction on how many characters to show. As an example: I've seen many mods (I'm also doing it) giving you the ability to show xx characters of title (usally in widgets or forum sidebar blocks). Let's say that you set it to 30 characters. If the 30th character is a special character getting double quote space, then you'll see that strange symbol instead the real character.

[Gardarika]

@ Christos

The main problem for me was accordance of language (coding) datebase and the forum, with the same language all problem's disappeared. I have russification for my forum, so all is ok now.