Datatype Dilemma

Well I considered putting this in another Forum...but there is really nothing in the web masterworld that is related to DataBases. Although it is related to .NET and ASP.NET technologies. Anyways I just created some tools to accomodate a site...these tools are simply tools that populate a database (MS Sql 2k). Anyways one of the functions of the tools is to upload a .plan (basically your plan in the next couple of months...but just think of paragraphs and paragraphs of data). Anyways I have written a string class in C# that handles unicode and ANSI conversions etc etc.

Currently I am storing the .plan in the DB as varchar(7500). Which is a limited amount of data I can have in the DB for that field....and we can't have that right?! So I am strongly considering to switching that field to Datatype: 'image'. image datatypes are not fixed and they are basically a binary field that isn't fixed. So is there a reason at all that I SHOULDn't be using this change that I want to do? I figure that my tool will be doing all of the conversions before hand so there is no performace hit. But I am going to be using an ASP.NET web site and if I make the change in the DB I have to pull from the DB and convert the Binary to a string to be able to display it.

So Is there really a difference on the ASP.NET side? I would think that it would actually increase performance because that would be one less step for the TCPIP stack to do...because it eventually get converted to binary at some point. So any thoughts or suggestions would be great.

Datatype Dilemma

things that make you go...hmm

RainMaker

Jimmy Turnip

RainMaker

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week