Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

types - Is there a prefered way to specify a text column in SQLite? -


since sqlite engine not truncate data store in text column, there advantage in being specific column sizes when define schema? prefer this:

create table contact(  id    integer primary key,   name  varchar(45),  title varchar(10) ); 

over this:

create table contact(  id    integer primary key,   name  text,  title text ); 

why?

are there advantages not being specific?

the advantage of using varchar(x) is compatible other database systems - if remember correctly, text isn't standard sql datatype.

other being more standards-compliant, there indeed no difference whether use text or varchar. more info @ http://sqlite.org/datatype3.html


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -