On Wed, April 20, 2005 3:20 pm, [EMAIL PROTECTED] said: > I have a table with a field that has a field of type LONGTEXT. I try to > insert a utf8 string with a length of 114544 and I get a warning that > text got truncated. According to the doc, the size of LONGTEXT is much > bigger than this. Any reason I get this warning?
I don't know anything about UTF-8, but is it possible that there is a special (to MySQL) character embedded in the string? For example, if the UTF-8 string contains ' and you don't escape that, it would cause a problem. Not *this* particular problem, probably, but that's just an example of what I mean. How are you inserting this? Is it possible that some buffer size somewhere, such as your query buffer, is just too small for that, so what got truncated was not the value, per se, but the whole query. -- Like Music? http://l-i-e.com/artists.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
