Sly
unread,Mar 25, 2013, 9:54:45 PM3/25/13Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to sql-...@googlegroups.com
I am kinda new to PHP, and SQL, as such i believe i might be doing something wrong. I have created my website and i have designed my database (MYSQL). I haven't had any problem with SQLbuddy until today when i tried to insert a TEXT datatype into a row in my MYSQL database.
*I am using wamp server version 2.2, mysql version 5-5-24, and sqlbuddy version 1.3.3.
* I created the column using this command: "ALTER TABLE table_name ADD COLUMN column_name TEXT NOT NULL;" (pls note here i have used "table_name" and "column_name" instead of the actual names i used). Now i am curious to know if there is anything wrong with my use of the "TEXT" datatype in the above statement.
*After creating this column, i now tried to enter my hand-written text using this command: "INSERT INTO table_name(column_name) VALUES(' here i typed a text with about 5000 characters '); "
I realised that when i try to insert a small text (about 500 characters), the text is smoothly inserted into the database without any problem, but when i try to fit in a larger text it gives me this error message "There was an error receiving data from the server" Now i have no idea what this is about. i have spent 12 hours today on this single problem....i have tried using a larger datatype such as "longtext " but i still get the same message when i try to insert a larger text in the database.
I have been using sqlbuddy since i started my study and i have come to like it, that is why i am reluctant to try out some other program. Any imediate response would be greatly apreciated. Thanks for your time and excuse the poor grammar...i am just frustrated!