473,398 Members | 2,088 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,398 software developers and data experts.

Problem with Text, LongText

Hi

I have a little problem with my database and php. In one of my tables i've
creted field of type Text. When i try to put some larger than 255 characters
to this field from php, that doesnt work. Script dont want to put text to my
table, strange. I try to chande type of this field to MediumText and
LongText and result is the same. This script send only max 255 characters by
field Textarea. Is this a problem whith my database or php problem with
controls textarea ?. Plizz help

Best regards
Adrian Majchrzak
Jul 20 '05 #1
2 3843
"Adrian Majchrzak" wrote:
Hi

I have a little problem with my database and php. In one of my tables i’ve
creted field of type Text. When i try to put some larger than 255
characters
to this field from php, that doesnt work. Script dont want to put text to my
table, strange. I try to chande type of this field to MediumText and LongText and result is the same. This script send only max 255
characters by
field Textarea. Is this a problem whith my database or php problem
with
controls textarea ?. Plizz help

Best regards
Adrian Majchrzak


Adrian, I think you may have some non-escaped characters in your input
text. Have you tried to input only alphanumerics, and see what
happens.

But in general, why don’t you write a sql statemetn with data over 255
characters, and see the db accepts them. The same way, why not see
what comes back from the form, and if you can type in more than 255
chars -which you should be able to. At least this way, you can
isolate the problem.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Proble...ict140585.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=470431
Jul 20 '05 #2
"steve" <Us************@dbForumz.com> дÈëÓʼþ
news:41**********@news.athenanews.com...
"Adrian Majchrzak" wrote:
> Hi
>
> I have a little problem with my database and php. In one of my tables
> i’ve
> creted field of type Text. When i try to put some larger than 255
> characters
> to this field from php, that doesnt work. Script dont want to put

text
> to my
> table, strange. I try to chande type of this field to MediumText

and
> LongText and result is the same. This script send only max 255
> characters by
> field Textarea. Is this a problem whith my database or php problem
> with
> controls textarea ?. Plizz help
>
> Best regards
> Adrian Majchrzak


Adrian, I think you may have some non-escaped characters in your input
text. Have you tried to input only alphanumerics, and see what
happens.

But in general, why don’t you write a sql statemetn with data over 255
characters, and see the db accepts them. The same way, why not see
what comes back from the form, and if you can type in more than 255
chars -which you should be able to. At least this way, you can
isolate the problem.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL:

http://www.dbForumz.com/mySQL-Proble...ict140585.html Visit Topic URL to contact author (reg. req'd). Report abuse:

http://www.dbForumz.com/eform.php?p=470431

Yes, may not be the field setting.

ccton
--
http://www.vicdir.com
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Adrian Majchrzak | last post by:
Hi I have a little problem with my database and php. In one of my tables i've creted field of type Text. When i try to put some larger than 255 characters to this field from php, that doesnt...
1
by: iporter | last post by:
Hi - I am changing a field from type nvarchar to type text, given that I need to store strings longer than 255 characters. To do this I change the data type in SQL Server, then I change the...
7
by: charliewest | last post by:
Using .Net CF, i have created a 2 dimension ArrayList, and "binded" this list to a ComboBox control using the "DataSource" property. I have set the DisplaySource and ValueMember properties as well....
1
by: Sunil Menon | last post by:
Dear All, I have a Web application that has a long Text field. User can put in any amount of data in this field. Is there a way to compress the value of the field from client side and send it to...
2
by: Mike Collins | last post by:
I cannot get the correct drop down list value from a drop down I have on my web form. I get the initial value that was loaded in the list. It was asked by someone else what the autopostback was...
3
by: rbutlerjr | last post by:
I've run into a strange problem with mysql_field_len returning -1 on any / all calls to it. This is on an Unbuntu Dapper system, with PHP 4.4.2, MySQL 4.1.15, and the PHP/MySQL Client API is...
1
by: sadf | last post by:
i am new to mysql and i want the syntax for inserting a large of data into the longtext field. please help me.
2
by: sadf | last post by:
I need to use MySql to store really large amounts of data . but when i try to store ,text file in long text field with LOAD_FILE command, the error i got was like : "Data too long for...
1
by: phpfreak2007 | last post by:
Hello, whenever I am using above 2 datatypes(longblob / longtext) my PC is not responding. I want to get data from the database (MySQL) to dataset. Thanks in advance.
3
pradeepjain
by: pradeepjain | last post by:
I have a table with fields like mysql> desc users; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default |...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.