SQL Server Management Studio R2 (varchar(MAX))
-
hi, i'm trying to create a program like notepad using visual basic. all of text body inside my note will be save in one cell in Sql Server Management Studio R2, but the max of varchar is varchar(8000), and there's varchar(MAX) too. nah if varchar(MAX) is bigger than 8000, may i know how many character it could save? i'm trying to understand this because i don't want any error caused by character overload. thankyou before. =)
-
hi, i'm trying to create a program like notepad using visual basic. all of text body inside my note will be save in one cell in Sql Server Management Studio R2, but the max of varchar is varchar(8000), and there's varchar(MAX) too. nah if varchar(MAX) is bigger than 8000, may i know how many character it could save? i'm trying to understand this because i don't want any error caused by character overload. thankyou before. =)
-
-
Actually it's rather nasty but it does get the point across. There are guidelines at the top which give you the same information in a more polite fashion. You, like the rest of us, obviously don't read the manual and just dived right in, most newbies get introduced to LMGTFY. Anyway welcome to the site, may your questions be clear and interesting.
Never underestimate the power of human stupidity RAH
-
Actually it's rather nasty but it does get the point across. There are guidelines at the top which give you the same information in a more polite fashion. You, like the rest of us, obviously don't read the manual and just dived right in, most newbies get introduced to LMGTFY. Anyway welcome to the site, may your questions be clear and interesting.
Never underestimate the power of human stupidity RAH
-
btw, varchar(max) indicates that the maximum storage size is 2^31-1 bytes is that means 2,147,483,648 - 1 become 2,147,483,647 characters? and then i don't have to worry about character overload anymore?
I should think that will be adequate for a
NotePadstyle application :-DNever underestimate the power of human stupidity RAH
-
I should think that will be adequate for a
NotePadstyle application :-DNever underestimate the power of human stupidity RAH
-
hi, i'm trying to create a program like notepad using visual basic. all of text body inside my note will be save in one cell in Sql Server Management Studio R2, but the max of varchar is varchar(8000), and there's varchar(MAX) too. nah if varchar(MAX) is bigger than 8000, may i know how many character it could save? i'm trying to understand this because i don't want any error caused by character overload. thankyou before. =)
vkstarry wrote:
the max of varchar is varchar(8000)
Yup, anything longer than that would cripple the database-index when you do a
LIKEoperation. To keep it simple; the documents contents should be a varchar(max) (or nvarchar if you need to store unicode), and you should use strings that are limited in length to describe other properties (like a title).Bastard Programmer from Hell :suss: