473,385 Members | 1,620 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

PhpMysqladmin field maximum length...

92
Field - description
Type - Text
Collation - utf8_general_ci

But i cant store my data, if its more description detail. what is maximum length to store lengthy values in that field.

Thanks in Advance
Dec 30 '09 #1
6 2133
Dormilich
8,658 Expert Mod 8TB
see MySQL documentation

text can take up roughly 65K characters, if you should require more, use mediumtext or longtext (up to 4 billion characters)
Dec 30 '09 #2
Limno
92
yes i m using this, but i m inserting my description field by

<textarea name="description" rows="3" id="transl2" style="width:600px; height:250px; color: black;"><?php echo $row1[2];?></textarea>

i cant insert my value using insert query
Dec 30 '09 #3
Dormilich
8,658 Expert Mod 8TB
any (MySQL) error messages?
Dec 30 '09 #4
Limno
92
Thanks, It's working.. i used addslashes() function.
Thank u again Torph.
Dec 30 '09 #5
Dormilich
8,658 Expert Mod 8TB
Thank u again Torph.
I’m neither Torph nor Toph (that’s my avatar*), I’m Dormilich.

* what a pun…
Dec 30 '09 #6
Limno
92
K Dormilich, Thank u soo much.
Please Keep in Touch
Dec 30 '09 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Rick Caborn | last post by:
Does anyone know of a way to execute sql code from a dynamically built text field? Before beginning, let me state that I know this db architecture is built solely for frustration and I hope to...
7
by: Mike | last post by:
I've been trying for the past week to put a simple code together. I have done a LOT of searching, found scripts showing the functions I would like to use, however when I mix them it all goes wrong,...
5
by: DotNetJunkies User | last post by:
Hi all, I have a question on how can I write the entire Dataset to a NTEXT field of SQLServer. Can anyone help me? Thanks! /mike
2
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.
2
by: G | last post by:
I would like to restrict the number of digits in a number field in the design of a table. eg. 16 digits maximum in a certain number field of a table. thanks.
2
by: Paulo Rodrigues | last post by:
Hi I would like some help about the following : I have a text field and I don't want it contains any numbers. How can I limit this situation ? So far, I couldn't find literature exacly...
4
by: Mark | last post by:
How can i get the maximum allowed length for a field in a SQL database? ie the value defined when creating a text field in a table, in a SQL database. As i want to set the max length of a text...
1
by: crjunk | last post by:
I'm trying to programmatically determine the maximum field length for an Access table. I've had problems using the examples that I have come across on the internet. Can anyone provide me with a...
4
by: =?Utf-8?B?cm9kY2hhcg==?= | last post by:
hey all, I'm doing the following: SqlCommand mycmd = new SqlCommand(sqlText, conn); SqlDataAdapter da = new SqlDataAdapter(mycmd); DataTable tbl = new DataTable(); da.Fill(tbl); Well, when I...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.