Click here to Skip to main content
       

Database

 
GeneralRe: Missing Data in an Access Report Pinmemberjschell7-Feb-13 9:52 
AnswerRe: Missing Data in an Access Report PinmemberMycroft Holmes6-Feb-13 12:27 
GeneralRe: Missing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 19:06 
GeneralRe: Missing Data in an Access Report PinmemberMycroft Holmes6-Feb-13 20:27 
GeneralRe: Missing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 20:32 
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 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberjschell3-Feb-13 6:36 
devvvy wrote:
I think it's the opposite. CHAR don't store trailing termination char (2 bytes for SQL), varchar does

 
Not sure what that statement means.
 
The 'char' data type is fixed length. That means that there will ALWAYS be 255 characters. And the way normal APIs to databases handle that is that they pad shorter lengths with spaces. Pretty sure that is an ANSI requirement as well.
 
devvvy wrote:
that's why you should always use VARCHAR(n) as supposed to VARCHAR(MAX)

 
Unless of course you know that you will be storing data larger than the largest integer value allowed for varchar(n).
 
devvvy wrote:
CHAR(n) when lenght same for all/most rows.

 
In normal database design most columns will be varchar because
1. User data is almost always variable
2. Application data that is text almost always has a variable length.
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 
GeneralRe: Identify DML changes between two databases PinmemberMember 313707830-Jan-13 21:26 
QuestionUpdate a flag based on portion of data avialble in other column Pinmemberyuvachandra30-Jan-13 10:20 
AnswerRe: Update a flag based on portion of data avialble in other column PinmemberMycroft Holmes30-Jan-13 11:56 
GeneralRe: Update a flag based on portion of data avialble in other column Pinmemberyuvachandra31-Jan-13 6:08 
GeneralRe: Update a flag based on portion of data avialble in other column PinmemberMycroft Holmes31-Jan-13 11:32 
GeneralRe: Update a flag based on portion of data avialble in other column Pinmemberyuvachandra31-Jan-13 11:45 
GeneralRe: Update a flag based on portion of data avialble in other column Pinmemberyuvachandra1-Feb-13 7:00 
Questionhow to comlex databinding with access database PinmemberAchilles8430-Jan-13 8:48 
AnswerRe: how to comlex databinding with access database PinmemberMycroft Holmes30-Jan-13 11:49 
GeneralRe: how to comlex databinding with access database PinmemberAchilles8430-Jan-13 20:49 
GeneralRe: how to comlex databinding with access database PinmemberMycroft Holmes30-Jan-13 21:06 
GeneralRe: how to comlex databinding with access database PinmemberAchilles841-Feb-13 0:25 
QuestionEnd Case in a Variable Pinmemberberba30-Jan-13 8:47 
AnswerRe: End Case in a Variable PinmemberMycroft Holmes30-Jan-13 11:46 
GeneralRe: End Case in a Variable Pinmemberberba30-Jan-13 18:02 
GeneralRe: End Case in a Variable PinmemberMycroft Holmes30-Jan-13 20:57 
QuestionWhat happens with auto-incremented value on rollback? Pinmemberpiticcotoc29-Jan-13 23:27 
AnswerRe: What happens with auto-incremented value on rollback? PinmemberJörgen Andersson30-Jan-13 1:04 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 3:02 
GeneralRe: What happens with auto-incremented value on rollback? Pinmembermark merrens30-Jan-13 5:33 

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
Web01 | 2.8.140916.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid