Most likely your size limitation is comming from the data type used for
'notes'. Check out the documentation for the size of the text types,
mediumtext may be more apropriate for you.
ryan
>
> I'm running into an odd string size limitation. I've traced it down as far
> as I can get, and I didn't run across anything in the docs or on any
> searches I've run so I figured I'd try here. The field in the database is
a
> TEXT type column. I'm appending to the front of the text field each time
> using:
>
> UPDATE field SET notes=CONCAT("newtext",notes) WHERE ...
>
> However the field is cutting off after 4096 bytes. With a hunch that
CONCAT
> may have been causing the limit, I switched to doing the concatenation
> inside of the application and setting the full field. The same cut-off
> occurs in storage, however the SQL executes correctly so it's not like the
> query is getting cut off and not seeing the WHERE clause.
>
> Seeing as this happens in CONCAT which should be server side I suspect I'm
> running into a server-side limitation. My app is PHP3 over IIS on NT4.0
> using MyODBC 2.50.3300 to a Linux Server running MySQL 3.22.32 precompiled
> (when you get 100 day 24/7 uptime no problem you don't upgrade!). What
> incredibly obvious piece of documentation am I missing, is this a "you
need
> to upgrade thing", or what would be a reasonable work-around in this
rather
> abstracted environment?
>
> Thanks,
> Sean
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
