https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 15:49:28 +0000 Mon, 10 Sep 2007 16:06:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24377 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/increase-maximum-characters-if-signature_topic24377_post127456.html#127456 Author: WebWiz-Bruce
Subject: 24377
Posted: 10 September 2007 at 4:06pm

No it's not just Access this effects. Larger field types should always be avoided where possiable.

If you do some searching on Google there is lots of papers on DBMS performance.
]]> Mon, 10 Sep 2007 16:06:23 +0000 https://forums.webwiz.net/increase-maximum-characters-if-signature_topic24377_post127456.html#127456 https://forums.webwiz.net/increase-maximum-characters-if-signature_topic24377_post127455.html#127455 Author: billd3
Subject: 24377
Posted: 10 September 2007 at 3:05pm

great answer, boRg, however, let's say that we run SQL, and will probably always run SQL, is there a limit in MS SQL 2005 or later, and if not, is there a way to manually increase that limit with a file edit, knowing what we are doing on our own forum?
I understand your default limit and it's probably wise, but what about an individual?
Does SQL have such a limit with that sort of field?
]]> Mon, 10 Sep 2007 15:05:47 +0000 https://forums.webwiz.net/increase-maximum-characters-if-signature_topic24377_post127455.html#127455 https://forums.webwiz.net/increase-maximum-characters-if-signature_topic24377_post127447.html#127447 Author: WebWiz-Bruce
Subject: 24377
Posted: 10 September 2007 at 9:26am

The reason for this limit is because many databases have a 255 character limit on some database types, and BBcodes increase the size of your signature.

Using a different datatype to hold more data reduces performance and increases server load due to the underlying way DBMS's work.
]]> Mon, 10 Sep 2007 09:26:59 +0000 https://forums.webwiz.net/increase-maximum-characters-if-signature_topic24377_post127447.html#127447 https://forums.webwiz.net/increase-maximum-characters-if-signature_topic24377_post127439.html#127439 Author: levis
Subject: 24377
Posted: 10 September 2007 at 5:25am

The maximum characters of signature at 200 is a bit little. How can i increase it?
Thanks!
]]> Mon, 10 Sep 2007 05:25:24 +0000 https://forums.webwiz.net/increase-maximum-characters-if-signature_topic24377_post127439.html#127439