Unable to use special characters

Question

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

Special character Ã&#131;

Error Message

Error creating issue: org.ofbiz.core.entity.GenericEntityException: while inserting:  GenericEntity:Issue  summary,Test Ã&#131;  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 _CFcon_ · Accepted Answer

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";