Click here to Skip to main content
       

Database

 
GeneralRe: Missing Data in an Access Report Pinmemberjschell7-Feb-13 9:56 
Questionoracle error with winserver2008 Pinmemberfares35-Feb-13 1:03 
AnswerRe: oracle error with winserver2008 PinmemberBernhard Hiller5-Feb-13 4:57 
Questionchar(255) vs varchar(255) vs varchar(MAX) Pinmemberdevvvy1-Feb-13 18:22 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) PinmvpRichard MacCutchan1-Feb-13 23:07 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) [modified] Pinmemberdevvvy2-Feb-13 15:39 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) PinmemberPIEBALDconsult2-Feb-13 5:22 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberdevvvy2-Feb-13 23:30 
I think it's the opposite. CHAR don't store trailing termination char (2 bytes for SQL), varchar does.
 
I think I found the answer. With VARCHAR(MAX), you can't index the column and also you don't have length checks provided for you by default by database, that's why you should always use VARCHAR(n) as supposed to VARCHAR(MAX)
 
CHAR(n) when lenght same for all/most rows.
dev

GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberjschell3-Feb-13 6:36 
QuestionSP Unexpected Behavior Pinmembereddieangel1-Feb-13 7:19 
QuestionEncrypt a field in the database. Pinmembervanikanc1-Feb-13 5:31 
AnswerRe: Encrypt a field in the database. PinmvpEddy Vluggen1-Feb-13 7:02 
Questioncheck before insert Pinmembervanikanc31-Jan-13 4:55 
AnswerRe: check before insert PinmvpEddy Vluggen31-Jan-13 5:00 
GeneralRe: check before insert PinmvpEddy Vluggen31-Jan-13 10:35 
AnswerRe: check before insert Pinmembermark merrens31-Jan-13 8:10 
GeneralRe: check before insert Pinmembervanikanc31-Jan-13 8:21 
GeneralRe: check before insert Pinmembermark merrens31-Jan-13 10:09 
GeneralRe: check before insert PinmemberChris Meech31-Jan-13 10:24 
GeneralRe: check before insert Pinmembermark merrens31-Jan-13 10:25 
AnswerRe: check before insert Pinmemberdjj551-Feb-13 7:50 
GeneralRe: check before insert Pinmembervanikanc1-Feb-13 7:55 
GeneralRe: check before insert Pinmemberdjj551-Feb-13 8:25 
QuestionIdentify DML changes between two databases PinmemberMember 313707830-Jan-13 20:56 
AnswerRe: Identify DML changes between two databases PinmemberMycroft Holmes30-Jan-13 21:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.140709.1 | Last Updated 12 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid