473,325 Members | 2,608 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,325 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 3839
"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: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.