Maximum column length - MySQL Database

Joe Goh

Hi there

Does anyone know what is the maximum column length for a table in a
MySQL database? I was thinking of storing feedback in the form of text
in the database. How feasible is this? Would appreciate any insights
or suggestions.

Thank you again

Joe

Jul 19 '05 #1

Subscribe Reply

6853

Randell D.

"Joe Goh" <jo****@mail.co m> wrote in message
news:33******** *************** ***@posting.goo gle.com...

Hi there

Does anyone know what is the maximum column length for a table in a
MySQL database? I was thinking of storing feedback in the form of text
in the database. How feasible is this? Would appreciate any insights
or suggestions.

Thank you again

Joe

Jul 19 '05 #2

Randell D.

"Joe Goh" <jo****@mail.co m> wrote in message
news:33******** *************** ***@posting.goo gle.com...

Hi there

Does anyone know what is the maximum column length for a table in a
MySQL database? I was thinking of storing feedback in the form of text
in the database. How feasible is this? Would appreciate any insights
or suggestions.

Thank you again

Joe

Jul 19 '05 #3

Randell D.

"Joe Goh" <jo****@mail.co m> wrote in message
news:33******** *************** ***@posting.goo gle.com...

Hi there

Does anyone know what is the maximum column length for a table in a
MySQL database? I was thinking of storing feedback in the form of text
in the database. How feasible is this? Would appreciate any insights
or suggestions.

Thank you again

Joe

In part, I believe one of the limitations is the table type you are using...
I am using the latest version 3 and have the MySQL windoze "chm" help file
which says:

"The maximum size of a BLOB or TEXT object is determined by its type, but
the largest value you can actually transmit between the client and server is
determined by the amount of available memory and the size of the
communications buffers. You can change the message buffer size, but you must
do so on both the server and client ends."

Its unlikely your feedback form though will hit the limit - I have a guest
book on my girlfriends website that I have limited to 2000characters (using
PHP I perform a substr() to get the first 2000). But I believe in theory I
could get away with megabytes (millions of characters) of text.

Jul 19 '05 #4

Randell D.

"Joe Goh" <jo****@mail.co m> wrote in message
news:33******** *************** ***@posting.goo gle.com...

Hi there

Does anyone know what is the maximum column length for a table in a
MySQL database? I was thinking of storing feedback in the form of text
in the database. How feasible is this? Would appreciate any insights
or suggestions.

Thank you again

Joe

Jul 19 '05 #5

Similar topics

555

Maximum column length

by: Joe Goh | last post by:

Hi there Does anyone know what is the maximum column length for a table in a MySQL database? I was thinking of storing feedback in the form of text in the database. How feasible is this? Would appreciate any insights or suggestions. Thank you again Joe

MySQL Database

4727

Maximum Line and String Lengths

by: Hal Vaughan | last post by:

Is there a maximum length for Javascript program lines? What about strings? Is there a limit on string length? I found some references that said the maximum string length was 256 characters, but I have a program that created a string of over 25,000 characters (the browser was Konqueror). Are there limits on these lengths? If I require a newer browser for the program I'm writing, would that change the situation?

Javascript

5011

The allowed maximum number of Columns and actual data in a row - What is it?

by: Dave Crypto | last post by:

Hi There, SUMMARY: I need to know what the actual maximum date limit possible on a row of a MYSQL database. MORE DETAILS: For example, does a MYSQL database only allow 4032 bytes of data to be

MySQL Database

36416

Maximum length for table names, colums etc.

by: Jens Riedel | last post by:

Hello, we are planning to port an application from one database to different others, including DB2. While reading the GettingStarted document for DB2 Personal Edition I got a little confused about the allowed length for object names. Did I understand this correct: table names -> 128 characters (if ANSI characters)

DB2 Database

28590

maximum size of a database/tablespace

by: Kums | last post by:

What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.

DB2 Database

2331

Maximum *width* of data in a table (Access 2003)

by: RKSpangler | last post by:

Greetings: Is there any way to determine the maximum width of all data elements in a particular column in a table? Sorting a column won't do it, of course, since it will use a collating sequence based on the content of the data. I want to know, for example, that the maximum width of a (non-blank) populated field in a table is, say, 10 (even though the field itself may be defined as width-255). Many thanks.

Microsoft Access / VBA

3592

Maximum size of table is 512G??

by: Woody Ling | last post by:

I am now using db2 v8.2 64bits without DPF. I want to create a very large table which is about 1000G and the record length is suitable for 32K page size. I find in the manual that the maximum size for 32K page size container is 512G only. Does it mean that the maximum size for 1 tablespace is also limited by 512G or I can create a tablespace with 2 containers (512G each) to support 1000G table? Thanks.

DB2 Database

1677

In gridview have to find out maximum length in column

by: Ramu528 | last post by:

Friends, I am working on excel sheet. i populated gridview with excel sheet data. the gridview has one column. have to find out the maximum length of String in that column. For example: gridviews has one column with three names Ram Murali Hari Krishna Murthy Sharma

.NET Framework

12115

What's your maximum line size preference?

by: Gianni Mariani | last post by:

Do you have a preference on maximum line width for C++ code? I've seen the craziest debates on this most silly of topic. I have witnessed engineers spent oodles of time fiddling with line breaks just to get it right. I find in general a prescriptive rule makes for markedly less readable code, which unfortunately is a subjective argument, however, the waste of time modifying code when it does not need to is not.

C / C++

8683

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8611

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8904

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8876

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5867

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4372

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4624

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3052

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2007

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General