limit on chars entered into database?

[trevor]

Well I thought everthing was working fine. For some reason when I tried to post news on my site it wont let me enter anything more than a couple lines.

Same with the forum.

I have it set up as message is 'text' in mysql.

am I missing something? WTF?

thanks all

-trevor <-- damn my name is showing up a lot on this forum

[sde]

asking questions is good trevor .. that is what this forum is for .. it's nice that it is getting some use =)

what is the data type in mysql of the news article field?

go into phpmyadmin and edit the field where the news article is stored. the data type needs to be "Medium Text"

[Admin]

hmm... im using the text datatype fine on several sites....

any reason to use medium text over text?

[sde]

right, i should rephrase, ..

don't use varchar 255

my only point is that his datatype is too small.

[Admin]

I have it set up as message is 'text' in mysql.

that looks like he has it set up as 'text' not 'varchar(255)'

text should be able to hold HUGE amounts of data.

perhaps i am missing something.

maybe trevor could give us a 'desc' of his table?

[sde]

oh, i missed that text thing =)

smalltext is equivilent to varchar(255) .. maybe that is it? we will have to hear from trevor.

[trevor]

hey all,

this is how it is set up:

Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
author text Yes NULL
header text Yes NULL
date text Yes NULL
time text Yes NULL
content text Yes NULL

any suggestions?

here is the url http://65.95.241.124/ao/ try posting something big on the forum and you wil see. I think sde already tried it out.

thanks all

-Trevor

[trevor]

i didnt all line up ass well as I had hoped

[sde]

http://www.mysql.com/doc/en/Column_types.html

there's the data types, .. and yes, text should be large enough. that is confusing, i don't know what the problem could be.

[trevor]

I tried posting a ton of jargon (over 1500 characters) and it went through?

gotta ponder this one.

[trevor]

are there any rules for characters you cant enter into a post or anything?

[trevor]

AH HA!!

I narrowed it down.

it doesn't seem to like --> '

single quotes always give an error?!?!

ideas?

[joe_bruin]

sql uses ' to delimit text.
in most sql implementations, a single quote is escaped with another single quote. ex:

select * from users where name='name with a '' single quote'

mysql uses c-style escape codes, a ' is escaped with a leading backslash (\)

select * from users where name='name with a \' single quote'

note that if you have php's magic_quote_escape (i think that's what it's called) environment variable turned on, php will automatically do the escaping for you for any post and get params.

[trevor]

how do you turn that on?

[trevor]

n/m that was it, i fixed it. magic_quotes was turned off.

THANKS ALL!!