Stack Overflow
Stack Overflow

Questions tagged [varcharmax]

The maximum count of type varchar

The maximum count of type varchar. A varchar or Variable Character Field is a set of character data of indeterminate length. The term varchar refers to a data of a field (or column) in a database management system. Varchar fields can be of any size up to a limit, which varies by databases: an Oracle 9i database has a limit of 4000 bytes, a MySQL database has a limit of 65,535 bytes (for the entire row) and Microsoft SQL Server 2005 has a limit of 8000 bytes (unless varchar(max) is used, which has a maximum storage capacity of 2 gigabytes).

71 questions
0
votes
1 answer

Getting Multiple Answers out of an XML String SQL

I have an XML document saved in a Column as varchar(max). The text I want is surrounded by Words I Wantbut these Text tags repeat sometimes 4 or 5 times. How do I loop through the same document x number of times dependent on the number…
user3774310
  • 31
  • 5
0
votes
2 answers

Mysterious:Selecting a large Xml in Sql Server

I am having a column in my table which stores XML data as a varchar(MAX).For example one of my value has around 1 LAC characters.While selecting it from the Table, i end up getting only 43679 characters for all samples. What is the reason behind…
Developer
  • 231
  • 4
  • 19
0
votes
0 answers

sql server select only part of string column in result set

I have table T with column A as Varchar(max) when I select this field in result pan it only show part of data of this column(only 1457 character) but len(A) return 1730 character. when I select A the result end with this…
user3587785
  • 3
  • 3
0
votes
1 answer

sql insert varchar or data

I'm developing application, which generate big html reports. I need to store data in temp tables in DB for html pages. Which is the best way to do it? Generate big xml string in table tmpTable(num, xmlStr)(xmlStr - aprox. 400 Kb) for HTML page,…
Mikhail Sokolov
  • 546
  • 1
  • 7
  • 18
0
votes
0 answers

Saving more than 111305 characters in varchar(MAX) SQL 2012

As the title says, I'm trying to save a PDF converted to base64 in SQL varchar(MAX) column. When my example PDF is converted to base64, is a 111305 characters length string. I copy and paste that string to SQL varchar(MAX) column, but when I do a…
GalloPinto
  • 667
  • 2
  • 11
  • 25
0
votes
0 answers

Searching for quotation marks in a varchar(max) field

I have a field in a table set to VARCHAR(MAX) and I am unable to search for quotation marks ["]. If I search for any other character it is working. select * from xml_file_log where request like '%"%'
Richard
  • 1
0
votes
1 answer

Search text within Varchar(max) column of Sql server

I wanted to write a t-sql query which finds values within a column of a sql server table. Example, CREATE TABLE Transactions (Details varchar(max)); Details Column has below type strings stored in…
Joe
  • 47
  • 1
  • 6
0
votes
1 answer

Storing distance matrix as VarChar(Max) in SQL Server database

I'm developing a fleet scheduling application and look for an effective way to store distances between geographic locations. The application-code accesses the matrix as a two-dimensional array double[,]. In order to make the matrix persistent, I…
curiosity
  • 201
  • 1
  • 4
  • 12
-1
votes
1 answer

Best practice of creating table with CSV file & using Varchar(MAX)

I have a question regards to creating a table in Azure SQL Server by importing a flat file (csv). I am having an issue with size of length with table I created (if size exceeds, I get an error), so I decided to go with all varchar(max) and allow…
Java
  • 1,208
  • 3
  • 15
  • 29
-1
votes
1 answer

How to convert a column wit varchar(max) in int

I have the following problem: I have a table ArticleDescription with columns like this: ID (int) Description (varchar(max)) 1 Muller Bogen, chrome-14440416700-55 2 Muller Bogen, chrome-14440416700-55 3 …
Luebeck
  • 9
-2
votes
1 answer

Two Identical queries one with SQL parameter and other with hard code string value providing different result set

Two identical Queries are returning different results in where clause. The first query is with SQL parameter variable and the second query with a string value as mentioned below. The result of both queries should be the same as both have the same…
Ishfaq Babar
  • 3
  • 4
1 2 3 4
5