Increase Signature length?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25946
Printed Date: 02 April 2026 at 11:51pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Increase Signature length?
Posted By: JohnLug
Subject: Increase Signature length?
Date Posted: 09 July 2008 at 6:11pm
|
I need to be able to increase the amount of characters in the signature. Any idea were and if possible?
|
Replies:
Posted By: JohnLug
Date Posted: 15 July 2008 at 11:55pm
|
No one has any idea on this??
I REALLY need to do this if possible
TKS
|
Posted By: i2Paq
Date Posted: 16 July 2008 at 6:12am
|
Change the database table lenght plus adjust the box-size? |
Posted By: JohnLug
Date Posted: 16 July 2008 at 10:27pm
|
I've tried that and have been able to get to 225 charachters. There's got to be an easy way, but I seem to be missing it. :(
Oh, using MSSQL also
|
Posted By: WebWiz-Bruce
Date Posted: 17 July 2008 at 8:39am
|
You need to change the SQL Server database field type to something like nText or Text to allow larger amounts of data. However, the larger fields do make your database work harder and so can effect performance. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: JohnLug
Date Posted: 17 July 2008 at 4:35pm
Maybe a dumb question here, but like I said, I'm new to MSSQL. ...
I "think" I found where to change it in the DB...
[Signature] [nvarchar] (255) NULL,Do I change it to (for example)
[Signature] [nText](1000) NULL,
And then save and "Run" the query again?
Will this keep the data already in there?
I can't afford to delete what's already there.
|
WebWiz-Bruce wrote:Posted By: WebWiz-Bruce
Date Posted: 17 July 2008 at 4:46pm
|
Yes change the [nText] you will not loose any data as the field size is increased.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: JohnLug
Date Posted: 17 July 2008 at 5:55pm
|
I tried changing the line to
[Signature] [nText](1000) NULL,
and then executing, and get the error...
Msg 2716, Level 16, State 1, Line 1 Column, parameter, or variable #20: Cannot specify a column width on data type ntext. So I know I'm doing something wrong. :) (Access was so easy :(, SQL is rough) |
Posted By: WebWiz-Bruce
Date Posted: 18 July 2008 at 7:57am
|
Try using [Text] instead, you may have better luck.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: TekNiko
Date Posted: 07 August 2008 at 11:15am
|
I've increased the field size but now where i can adjust the box-size?
the number of characters in still 200
|
Posted By: Atomic Taco
Date Posted: 06 February 2009 at 6:31am
|
What table is the "Signature" field in?
And where does the box size get adjusted? |