[Typo3] unusual single quote ( ' ) error - WAS short content element

[Christopher]

Hello,

On 6/22/05, Jacob Floyd <techgurufloyd at gmail.com> wrote:
> Moving to a new thread to better explain problem.
> 
> I have a typo3 3.8.0 install on windows with MySQL 4.1.12 and have a
> very strange problem.
> 
> Whenever I put a single right quote (HTML: "&rsquo;" ) in one a text
> content element, I get the error:
> 
> Errors:
> 102: These fields are not properly updated in database: (bodytext)
> Probably value mismatch with fieldtype.
> 
> It then cuts the single quote and everything after it out saving only
> the content before it.
> 
> I can not duplicate this error on my other typo3 3.7.0 install on
> redhat linux with MySQL 4.0.22
> 
> Another user, Cristopher, was not able to reproduce the error on
> either of his installs.
> 
> Can anyone suggest a course of action? Where should I look and what
> should I change to resolve this issue?
> 
> Thanks for all the invaluable help I've received.
> Jacob Floyd

The only thing I can think of that might be responsible for this is
that somehow that quote is being mistaken as the closing quote in the
sql statement; e.g.

UPDATE table SET field='String of text containing some quotation marks
(like this one ' and this one ') before the end of a sentence';

...I guess that this would explain why you get everything up to the
first single quote. Of course, I have _no_ clue why single quotes
would cause problems in your instance and not in any others that I've
heard of. It's odd.

Question: If you insert a ">" and a "<" in the same content element
and then view the resulting page, do they show as ">" and "<" or as
"&gt;" and "&lt;"?

-Christopher