Panel
PowerQA is a state of the art discussion software that makes online discussions fun. It's simple, fast, and powerful.
Menu
OR
AND
Login
Login
Register
PowerQA
Another platform for face to face community
Q&A
Activity
Questions
Hot!
Unanswered
Featured
Categories
Tags
Users
Ask a Question
About
JA
Newbie
gurjyot singh
+1
vote
676
views
Increase character set limit from 8000 to 16000
Many times my users have complained that they get this message due to long answers. So I have to change it in core manually. But why not to increase it in core because many professional websites would be facing same problem like me.
character-limit
core
by
gurjyot singh
asked
Aug 24, 2015
in
Core
4 Comments
Good suggestion. I also have the same experience. In particular, it seems to occur when we copied a complex HTML. Program changes is easy. But, to do this, database changes is also required. I worry about character size limitations and MySQL performance of innoDB.
Limit of textarea is 32,767 bytes (OK).
Limit of varchar is 65,535 bytes / 21,845 UTF-character (OK).
Reference:
http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html
http://stackoverflow.com/questions/19472004/mysql-innodb-varchar-performance-versus-text-on-inserts
http://stackoverflow.com/questions/1962310/importance-of-varchar-length-in-mysql-table
https://www.percona.com/blog/2010/02/09/blob-storage-in-innodb/
Do you have a reliable information?
Sorry sama but I am not the guy with much knowledge about coding. I can tell you different ways to promote your software but this coding part you have to figure out on your own. I hope you understand.
Do not worry. My word of "you" means everyone (e.g. Vanbells , etc). Gideon is a database specialist. So, there is surely why he was limited to 8000. I want to know it.
There have a been a debate about this issue on q2a
http://www.question2answer.org/qa/39622/there-efficiency-security-concerns-increasing-content-limit
I believe Gideon used varchar for performance reasons.
The logical way to increase the the character length is by changing from VARCHAR to text (longtext, medium text etc). Text takes a long time especially during an update query compared to varchar. So I believe maybe we can run some bench marks?
I still dont know why he chose 8000 though. He might have a very good reason for that or maybe it was a random figure but we can run some tests with varying figures.
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
Related questions
Newbie
yerbol89
+1
vote
538
views
QA
in
Core
How i redirect my domain in subdomain?
core
htaccess
by
yerbol89
asked
Nov 9, 2015
in
Core
Newbie
yerbol89
2
answers
0
votes
948
views
in
Core
How i add auto redirect http for https
core
https
http
by
yerbol89
asked
Aug 29, 2015
in
Core
Newbie
gurjyot singh
3
answers
+3
votes
1,761
views
in
Core
Feature Request: Warn on leave
plugin
core
feature-request
by
gurjyot singh
asked
Aug 20, 2015
in
Core
Newbie
gurjyot singh
1
answer
+2
votes
2,083
views
in
Core
Some basic improvement requests.
requests
improvements
core
powerqa
by
gurjyot singh
asked
Aug 20, 2015
in
Core
Hunter
Jonatan
+3
votes
731
views
in
Core
I can give some suggestions?
powerqa
q2a
core
notications
side-panel
by
Jonatan
asked
Aug 20, 2015
in
Core
Welcome to PowerQA. PowerQA is a new discussion software (
not OSS
). Here is a community for PowerQA developers. Current stable version is
V1.9.4
. It is enhanced day by day.
All categories
Program
286
Core
141
Plugins
105
Themes
28
Langs
4
Document
4
Announcement
18
Others
30
Popular tags
bug
30
version
20
plugin
17
release
16
user
16
menu
16
widget
10
site
10
shortcode
9
editor
9
notification
9
compatibility
9
mobile
9
position
8
post
8
page
8
type
7
issue
7
core
7
theme
7
file
6
ckeditor
6
cache
6
design
6
login
6
form
6
category
6
search
6
dashboard
5
setting
5
error
5
ajax
5
javascript
5
image
5
download
5
admin
5
ask
5
help
5
question
5
popup
4
team
4
count
4
private
4
lang
4
color
4
install
4
home
4
default
4
test
4
pqa
4
Statistics
338
questions
276
answers
480
comments
100
users
Post types
74
QA
24
Discus
166
Notice
23
Report
15
Test
18
Suggest
Q&A
Activity
Questions
1
Hot!
Unanswered
1
Featured
Categories
Tags
Users
Ask a Question
JA
About
Login
Register
...