Unable to use special characters

[Klaus Zinsmeister]

When we want to use some special characters for comments or description our JIRA Instance throws error

Special character Ã

Error Message

Error creating issue: org.ofbiz.core.entity.GenericEntityException: while inserting: GenericEntity:Issue summary,Test à status,1 votes,0 assignee,zinsmeik security,null resolutiondate,null type,3 timespent,null id,12234 reporter,zinsmeik project,10005 environment,null created,2013-02-20 12:04:45.073 updated,2013-02-20 12:04:45.073 workflowId,13234 description,test ticket priority,3 timeestimate,null duedate,null timeoriginalestimate,null watches,0 key,CMTEST-35 (SQL Exception while executing the following:INSERT INTO jiraissue (ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, RESOLUTIONDATE, VOTES, WATCHES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: ' xC2 x83' for column 'SUMMARY' at row 1))

Database collation is latin1_swedish_ci

[C_ Faysal · Accepted solution]

hi Klaus.

how was the database set up?

did you followed these instructions?

https://confluence.atlassian.com/display/JIRA/Setting+Up+a+MySQL+Database+on+Linux+for+JIRA

https://confluence.atlassian.com/display/JIRA/Configuring+MySQL+5.1+to+store+non-ASCII+characters

i guess not.

Database collation is latin1_swedish_ci

what should be utf8

can you please run

mysql> show CREATE DATABASE <yourJiraDB>;

also these queries show some info:

mysql> show variables like "character_set_database";
mysql> show variables like "collation_database";

[Klaus Zinsmeister]

Hi, thanks I need to convert the database to UTF-8.