Question about characters limit? | Bitcointalksearch.org

theymos

administrator

Activity: 5166

Merit: 12850

Quote from: anonymoustroll420 on December 11, 2016, 05:52:56 PM

It's not so simple as the character limit in mysql, the database server that the forum presumably uses, is 65,535 bytes for a VARCHAR: https://dev.mysql.com/doc/refman/5.7/en/char.html

Fixing this would mean some major changes to the forums software, which likely won't happen in this software, but the new forum software that is being developed uses a different database server which may not have this limit. So something like you propose is much easier to do with the new forum software.

Yes, it's a technical limitation. Epochtalk doesn't have the same limitation, though IIRC as of now there's a soft 64k character limit (rather than byte limit), since it seems prudent to have some limit.

btcdevil

legendary

Activity: 1302

Merit: 1027

Quote from: Jet Cash on December 13, 2016, 03:06:40 AM

I find very long posts a bit offputting, and I often only read the first paragraph. For me, it is easier if the poster splits the message into two (or more) blocks, and submits those as separate, but adjacent, posts.

This is upto the users wish of viewing it, but the question OP have raised is good and i think most of them have got cleared their doubts as i have seen lot of Translators are facing this problem but no one came forward to ask it openly. Now i think all of them have got cleared their doubts of Translators limits

Jet Cash

legendary

Activity: 2688

Merit: 2444

https://JetCash.com

I find very long posts a bit offputting, and I often only read the first paragraph. For me, it is easier if the poster splits the message into two (or more) blocks, and submits those as separate, but adjacent, posts.

anonymoustroll420

full member

Activity: 196

Merit: 101

Quote from: btvGainer on December 11, 2016, 06:45:42 AM

I second this idea. It will definitely help everyone particularly users posting in local forums in their own language as different language use different amount of bytes (as theymos enlightened us). A good option would be,as suggested, to add a Read More option appear after a certain characters limit so it doesn't look too long if that post is quoted by someone

It's not so simple as the character limit in mysql, the database server that the forum presumably uses, is 65,535 bytes for a VARCHAR: https://dev.mysql.com/doc/refman/5.7/en/char.html

Fixing this would mean some major changes to the forums software, which likely won't happen in this software, but the new forum software that is being developed uses a different database server which may not have this limit. So something like you propose is much easier to do with the new forum software.

btvGainer

legendary

Activity: 854

Merit: 1000

Quote from: lottery248 on December 10, 2016, 09:11:06 PM

Quote from: theymos on December 10, 2016, 07:57:13 PM

Quote from: theymos on May 10, 2016, 12:25:11 PM

Posts over 65535 bytes get cut off at 65535 bytes. If that makes the BBcode invalid in certain ways, then you get the INVALID BBCODE error.

Also, note that a byte is different from a character. Because SMF stores "special" characters in a particularly space-inefficient way, each Russian character uses about 6 bytes, and each line break also uses 6 bytes.

by the way theymos, i would wish to know something about, because some of the people writes more than 65535 bytes, for an example: https://bitcointalksearch.org/topic/how-999dicecom-is-stealing-your-coins-and-exactly-why-you-wont-believe-me-948965 which had to use two posts to complete his content.

are there any plans to increase the byte limit to let the people make a more detailed reply or something?

maybe we can impose a hidden post policy which is applied to the long posts, which is not loaded without asking permission of the thread reader. Huh

I second this idea. It will definitely help everyone particularly users posting in local forums in their own language as different language use different amount of bytes (as theymos enlightened us). A good option would be,as suggested, to add a Read More option appear after a certain characters limit so it doesn't look too long if that post is quoted by someone

lottery248

legendary

Activity: 1568

Merit: 1005

beware of your keys.

Quote from: theymos on December 10, 2016, 07:57:13 PM

Quote from: theymos on May 10, 2016, 12:25:11 PM

Posts over 65535 bytes get cut off at 65535 bytes. If that makes the BBcode invalid in certain ways, then you get the INVALID BBCODE error.

Also, note that a byte is different from a character. Because SMF stores "special" characters in a particularly space-inefficient way, each Russian character uses about 6 bytes, and each line break also uses 6 bytes.

by the way theymos, i would wish to know something about, because some of the people writes more than 65535 bytes, for an example: https://bitcointalksearch.org/topic/how-999dicecom-is-stealing-your-coins-and-exactly-why-you-wont-believe-me-948965 which had to use two posts to complete his content.

are there any plans to increase the byte limit to let the people make a more detailed reply or something?

maybe we can impose a hidden post policy which is applied to the long posts, which is not loaded without asking permission of the thread reader. Huh

theymos

administrator

Activity: 5166

Merit: 12850

Quote from: theymos on May 10, 2016, 12:25:11 PM

Posts over 65535 bytes get cut off at 65535 bytes. If that makes the BBcode invalid in certain ways, then you get the INVALID BBCODE error.

Also, note that a byte is different from a character. Because SMF stores "special" characters in a particularly space-inefficient way, each Russian character uses about 6 bytes, and each line break also uses 6 bytes.

hilariousandco

global moderator

Activity: 3794

Merit: 2615

Join the world-leading crypto sportsbook NOW!

Not unless theymos changes if for you, but there's no guarantee the new forum software will have a bigger character limit either.

btvGainer

legendary

Activity: 854

Merit: 1000

Quote from: hilariousandco on December 10, 2016, 05:57:07 AM

Quote from: btvGainer on December 10, 2016, 05:55:09 AM

I want to ask is characters limit in a post different for different ranks?

I don't believe so. The character count limit is probably just a default limitation of the forum software.

That means there is no way we can have longer limit unless new version is launched?

Vod

legendary

Activity: 3668

Merit: 3010

Licking my boob since 1970

SMF 1.1.2 cuts off posts that are larger than about 61000 characters

SMF 1.1.19 is probably the same.

hilariousandco

global moderator

Activity: 3794

Merit: 2615

Join the world-leading crypto sportsbook NOW!

Quote from: btvGainer on December 10, 2016, 05:55:09 AM

I want to ask is characters limit in a post different for different ranks?

I don't believe so. The character count limit is probably just a default limitation of the forum software.

btvGainer

legendary

Activity: 854

Merit: 1000

Recently I was translating a ANN thread from English to my language and when I tried to post it,my post was shortened and only a portion of translated thread was posted.
I was confused that while original poster was one rank below to mine, how could he posted the long thread but I am unable.
I soon realized that Hindi translation had more characters in it then original English.
I want to ask is characters limit in a post different for different ranks?
or is it some way to get this limited removed to post long threads like translation etc?

Topic: Question about characters limit? (Read 828 times)