Some characters not accepted in entry text

Janine · Post by **Janine** » Tue Apr 03, 2007 7:34 pm

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?

Janine · Post by **Janine** » Tue Apr 03, 2007 7:36 pm

For example: „hello” is not accepted

judebert · Post by **judebert** » Wed Apr 04, 2007 3:43 pm

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.

Post by **garvinhicking** » Wed Apr 04, 2007 5:22 pm

Hi!

Also which database are you using? MySQL?

Regards,
Garvin

Janine · Post by **Janine** » Thu Apr 05, 2007 10:14 pm

Yes, MySQL latest version!

Post by **garvinhicking** » Thu Apr 05, 2007 10:39 pm

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