Serendipity Forums

Im having problems posting some characters in the entry body. One character that gives problems is: ”

The error that appears is:

Error:

INSERT INTO serendipity_entries (title,timestamp,body,extended,isdraft,allow_comments,moderate_comments,exflag,comments,last_modified,author,authorid) values ('Test', '1175621306', '”', '', 'false', 'true', 'false', '0', '0', '1175621306', 'John Doe', '1')

/ Data too long for column 'body' at row 1

When I remove this character from my text the entry is approved!

Any ideas what might be the cause?

For example: „hello” is not accepted

What are the character encodings for your blog and your database? If they're both UTF-8, I would expect this to work. If they don't match, or they're some ASCII derivative, I would expect this to fail.

Hi!

Also which database are you using? MySQL?

Regards,
Garvin

Yes, MySQL latest version!

Hi!

Okay, then judebert should be right. Did you check your MySQL charsets/collations of the serendipity_entries table? Something must be mismatching there...

Best regards,
Garvin