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
