| Author |
Topic Search Topic Options
|
Akura
New Poster
Joined: 05 Jun 2010
Status: Offline
Points: 37
|
Topic: Player profile Posted: 05 Jun 2010 at 03:16 |
|
Just wondering, is there a limit to the size of the profile?
And can BBCode or HTML be used for it?
|
 |
Wuzzel
Postmaster
Joined: 26 Feb 2010
Status: Offline
Points: 605
|
Posted: 05 Jun 2010 at 11:02 |
|
Just test it and you can see for yourself Akura. I have no idea.
|
|
|
 |
HonoredMule
Postmaster General
Joined: 05 Mar 2010
Location: Canada
Status: Offline
Points: 1650
|
Posted: 07 Jun 2010 at 16:35 |
|
Well there's no limit in the actual specification for POST, but there will be a practical limit to the amount of POST data the webserver will accept (to protect against denial os service and buffer overflow attacks), but that could be as high as two megabytes of text. Single fields are often limited to 1024 characters, but this limit can also be adjusted.
I'm sure there is some limit to the size of the database field that stores it as well. Without any proper checking or synchronized configuration between webserver and db server, your profile could just get silently truncated to the amount that is actually stored.
|
 |
Akura
New Poster
Joined: 05 Jun 2010
Status: Offline
Points: 37
|
Posted: 07 Jun 2010 at 22:40 |
|
Oh, I figured out what the limit is. It cut off the last paragraph or two, which weren't all that important.
|
 |
HonoredMule
Postmaster General
Joined: 05 Mar 2010
Location: Canada
Status: Offline
Points: 1650
|
Posted: 08 Jun 2010 at 10:40 |
|
The suspense is killing me. What was the accepted character count?
|
 |
Duke Felirae
Greenhorn
Joined: 08 May 2010
Status: Offline
Points: 76
|
Posted: 08 Jun 2010 at 10:51 |
|
6577 not including spaces, 7956 including spaces.
|
|
His Grace the Duke of Felirae
|
 |
HonoredMule
Postmaster General
Joined: 05 Mar 2010
Location: Canada
Status: Offline
Points: 1650
|
Posted: 08 Jun 2010 at 19:20 |
|
So likely 8,000 then, with losses for some character escaping.
|
 |
GM Stormcrow
Moderator Group
GM
Joined: 23 Feb 2010
Location: Illyria
Status: Offline
Points: 3820
|
Posted: 08 Jun 2010 at 21:21 |
|
Yes indeed, I'm pretty sure it's a varchar(8000) input field.
We could, of course, increase it to varchar(max) but we sort-of think the "Public Forum" area for each alliance is where people could post the extra information they want. The Profile shouldn't be War & Peace.
|
 |
HonoredMule
Postmaster General
Joined: 05 Mar 2010
Location: Canada
Status: Offline
Points: 1650
|
Posted: 08 Jun 2010 at 21:52 |
|
8k chars was sufficient for Harmless' rather comprehensive profile, including overhead of html markup.
|
 |