Opened 5 years ago

Closed 4 years ago

#2188 closed bug (worksforme)

Polish characters are not shown correctly in comments to activities

Reported by: sitatara Owned by:
Priority: minor Milestone: unassigned
Component: BW Activities Keywords: character encoding, languages, activities
Cc:

Description

A member reported: "For this event, http://www.bewelcome.org/activities/854, I posted a comment in Polish, to discover that the characters 'ł' 'ę' and 'ż' are replaced by question marks. I assume all Polish character's are not shown as they ought to be. I left my comment so you can see what I meant. It ought to have read "Byłem tam przed i można będę tam ten rok też". Note that the Polish letter 'ą' shows correctly in the location information.

List of non-english Polish characters if required: Ą, ą, Ć, ć, Ę, ę, Ł, ł, Ń, ń, Ó, ó, Ś, ś, Ż, ż, Ź, ź"

Change History (2)

comment:1 Changed 4 years ago by shevek

The database schema needs an update to utf-8:

ALTER TABLE `activitiesattendees` CHANGE `comment` `comment` VARCHAR(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

Applied to local DB works fine. Fixed on live as well.

comment:2 Changed 4 years ago by shevek

  • Resolution set to worksforme
  • Status changed from new to closed

Closed as worksforme as no code change was necessary.

Note: See TracTickets for help on using tickets.