Opened 9 years ago

Closed 8 years ago

#4163 closed defect (wontfix)

rails/postgres error when sending message with special character

Reported by: woodpeck Owned by: rails-dev@…
Priority: minor Milestone:
Component: website Version:
Keywords: Cc:


I am relaying this message from the German forum:

Someone tried to send a message through user-to-user-messaging and got a strange "PGError: ERROR: invalid byte sequence for encoding "UTF8": 0xfc" message. 0xfc is ISO-8859-1 for a common German special character (ü). I can send messages containing that letter with no problem. I suspect that for some reason if a browser doesn't send UTF-8 but ISO-8859-1 then it breaks. No idea if this is the browser's or server's fault though!

I recommended not using special characters as a workaround.

Change History (3)

comment:1 Changed 9 years ago by Tom Hughes

This is a tricky area as there is no way to tell what encoding a browser has used for the form data it sends, or to tell it to use a particular encoding.

There are various things you can do to try and persuade the major browsers to send data as UTF-8 but nothing that is 100% guaranteed to work everywhere.

comment:2 Changed 9 years ago by Tom Hughes

I think we're probably doing everything we can here to be honest - we (well rails anyway) are setting accept-charset="UTF-8" on the form and adding a hidden field with a UTF-8 encoded value.

Both of those are things which will persuade some browsers to return form data as UTF-8 but obviously not all browsers...

Could you find out what browser the user reporting the problem was using?

comment:3 Changed 8 years ago by Tom Hughes

Resolution: wontfix
Status: newclosed

I'm closing this given that's it not clear there is anything we can do, and we have no idea what browser triggered the problem.

Note: See TracTickets for help on using tickets.