UBB.Developers Forums UBB.threads 7 Development How Do I? SQL TEXT Datatype question

Signatures on my board are being cut off around 213 characters (are carriage returns considered characters by the way?)

I had the signature limit at 500 in the config. I pulled up phpmyadmin and took a look at the sig field. It's set as TEXT but the Length/Set is not set. I tried to set it but it would not let me. Recieved a syntax error.

From what I understand in MySQL the TEXT datatype is a variable-length datatype with max length at 64KB. So I'm guessing the Length/Set needs no value. Is this correct?

If so, then why are values being cut off in that field?

Any ideas and/or suggestions? I realize enforcing smaller sig's would work and help with performance...maybe this is my best option. Just curious as to why this is happening though.

So you altered the B_Signature field? You might want to try doing this from the mysql prompt:

ALTER TABLE w3t_Posts CHANGE B_Signature B_Signature TEXT