Click here to Skip to main content
13,250,453 members (52,901 online)
   

Database

 
GeneralRe: Missing Data in an Access Report Pin
Vuyiswa Maseko6-Feb-13 20:01
memberVuyiswa Maseko6-Feb-13 20:01 
GeneralRe: Missing Data in an Access Report Pin
jschell7-Feb-13 10:52
memberjschell7-Feb-13 10:52 
AnswerRe: Missing Data in an Access Report Pin
Mycroft Holmes6-Feb-13 13:27
memberMycroft Holmes6-Feb-13 13:27 
GeneralRe: Missing Data in an Access Report Pin
Vuyiswa Maseko6-Feb-13 20:06
memberVuyiswa Maseko6-Feb-13 20:06 
GeneralRe: Missing Data in an Access Report Pin
Mycroft Holmes6-Feb-13 21:27
memberMycroft Holmes6-Feb-13 21:27 
GeneralRe: Missing Data in an Access Report Pin
Vuyiswa Maseko6-Feb-13 21:32
memberVuyiswa Maseko6-Feb-13 21:32 
GeneralRe: Missing Data in an Access Report Pin
jschell7-Feb-13 10:56
memberjschell7-Feb-13 10:56 
Questionoracle error with winserver2008 Pin
fares35-Feb-13 2:03
memberfares35-Feb-13 2:03 
AnswerRe: oracle error with winserver2008 Pin
Bernhard Hiller5-Feb-13 5:57
memberBernhard Hiller5-Feb-13 5:57 
Questionchar(255) vs varchar(255) vs varchar(MAX) Pin
devvvy1-Feb-13 19:22
memberdevvvy1-Feb-13 19:22 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) Pin
Richard MacCutchan2-Feb-13 0:07
mvpRichard MacCutchan2-Feb-13 0:07 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pin
devvvy2-Feb-13 16:39
memberdevvvy2-Feb-13 16:39 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) Pin
PIEBALDconsult2-Feb-13 6:22
memberPIEBALDconsult2-Feb-13 6:22 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pin
devvvy3-Feb-13 0:30
memberdevvvy3-Feb-13 0: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) Pin
jschell3-Feb-13 7:36
memberjschell3-Feb-13 7:36 
QuestionSP Unexpected Behavior Pin
eddieangel1-Feb-13 8:19
membereddieangel1-Feb-13 8:19 
QuestionEncrypt a field in the database. Pin
vanikanc1-Feb-13 6:31
membervanikanc1-Feb-13 6:31 
AnswerRe: Encrypt a field in the database. Pin
Eddy Vluggen1-Feb-13 8:02
mvpEddy Vluggen1-Feb-13 8:02 
Questioncheck before insert Pin
vanikanc31-Jan-13 5:55
membervanikanc31-Jan-13 5:55 
AnswerRe: check before insert Pin
Eddy Vluggen31-Jan-13 6:00
mvpEddy Vluggen31-Jan-13 6:00 
GeneralRe: check before insert Pin
Eddy Vluggen31-Jan-13 11:35
mvpEddy Vluggen31-Jan-13 11:35 
AnswerRe: check before insert Pin
mark merrens31-Jan-13 9:10
membermark merrens31-Jan-13 9:10 
GeneralRe: check before insert Pin
vanikanc31-Jan-13 9:21
membervanikanc31-Jan-13 9:21 
GeneralRe: check before insert Pin
mark merrens31-Jan-13 11:09
membermark merrens31-Jan-13 11:09 
GeneralRe: check before insert Pin
Chris Meech31-Jan-13 11:24
memberChris Meech31-Jan-13 11:24 
GeneralRe: check before insert Pin
mark merrens31-Jan-13 11:25
membermark merrens31-Jan-13 11:25 
AnswerRe: check before insert Pin
djj551-Feb-13 8:50
memberdjj551-Feb-13 8:50 
GeneralRe: check before insert Pin
vanikanc1-Feb-13 8:55
membervanikanc1-Feb-13 8:55 
GeneralRe: check before insert Pin
djj551-Feb-13 9:25
memberdjj551-Feb-13 9:25 
QuestionIdentify DML changes between two databases Pin
Member 313707830-Jan-13 21:56
memberMember 313707830-Jan-13 21:56 
AnswerRe: Identify DML changes between two databases Pin
Mycroft Holmes30-Jan-13 22:11
memberMycroft Holmes30-Jan-13 22:11 
GeneralRe: Identify DML changes between two databases Pin
Member 313707830-Jan-13 22:26
memberMember 313707830-Jan-13 22:26 
QuestionUpdate a flag based on portion of data avialble in other column Pin
yuvachandra30-Jan-13 11:20
memberyuvachandra30-Jan-13 11:20 
AnswerRe: Update a flag based on portion of data avialble in other column Pin
Mycroft Holmes30-Jan-13 12:56
memberMycroft Holmes30-Jan-13 12:56 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra31-Jan-13 7:08
memberyuvachandra31-Jan-13 7:08 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
Mycroft Holmes31-Jan-13 12:32
memberMycroft Holmes31-Jan-13 12:32 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra31-Jan-13 12:45
memberyuvachandra31-Jan-13 12:45 
GeneralRe: Update a flag based on portion of data avialble in other column Pin
yuvachandra1-Feb-13 8:00
memberyuvachandra1-Feb-13 8:00 
Questionhow to comlex databinding with access database Pin
Achilles8430-Jan-13 9:48
memberAchilles8430-Jan-13 9:48 
AnswerRe: how to comlex databinding with access database Pin
Mycroft Holmes30-Jan-13 12:49
memberMycroft Holmes30-Jan-13 12:49 
GeneralRe: how to comlex databinding with access database Pin
Achilles8430-Jan-13 21:49
memberAchilles8430-Jan-13 21:49 
GeneralRe: how to comlex databinding with access database Pin
Mycroft Holmes30-Jan-13 22:06
memberMycroft Holmes30-Jan-13 22:06 
GeneralRe: how to comlex databinding with access database Pin
Achilles841-Feb-13 1:25
memberAchilles841-Feb-13 1:25 
QuestionEnd Case in a Variable Pin
berba30-Jan-13 9:47
memberberba30-Jan-13 9:47 
AnswerRe: End Case in a Variable Pin
Mycroft Holmes30-Jan-13 12:46
memberMycroft Holmes30-Jan-13 12:46 
GeneralRe: End Case in a Variable Pin
berba30-Jan-13 19:02
memberberba30-Jan-13 19:02 
GeneralRe: End Case in a Variable Pin
Mycroft Holmes30-Jan-13 21:57
memberMycroft Holmes30-Jan-13 21:57 
QuestionWhat happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 0:27
memberpiticcotoc30-Jan-13 0:27 
AnswerRe: What happens with auto-incremented value on rollback? Pin
Jörgen Andersson30-Jan-13 2:04
memberJörgen Andersson30-Jan-13 2:04 
GeneralRe: What happens with auto-incremented value on rollback? Pin
piticcotoc30-Jan-13 4:02
memberpiticcotoc30-Jan-13 4:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 |
Web04 | 2.8.171114.1 | Last Updated 15 Nov 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid