Loading...

XML

Word

Printable

Type: Bug
Resolution: Fixed
Priority: Medium
Fix Version/s: 3.3
Affects Version/s: 3.2.3
Component/s: Installation
Labels:
None
Environment:

Hide

Java Version 1.4.1_05
Java Vendor Sun Microsystems Inc.
JVM Version 1.0
JVM Vendor Sun Microsystems Inc.
JVM Implementation Version 1.4.1_05-b01
Java Runtime Java(TM) 2 Runtime Environment, Standard Edition
Java VM Java HotSpot(TM) Server VM
User Name weblogic
User Timezone Canada/Eastern
User Locale English (Canada)
System Encoding ISO8859-1
Operating System SunOS 5.9
OS Architecture sparc
Application Server Container WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284
Database type mssql
Database JNDI address JiraDS

Show
Java Version 1.4.1_05 Java Vendor Sun Microsystems Inc. JVM Version 1.0 JVM Vendor Sun Microsystems Inc. JVM Implementation Version 1.4.1_05-b01 Java Runtime Java(TM) 2 Runtime Environment, Standard Edition Java VM Java HotSpot(TM) Server VM User Name weblogic User Timezone Canada/Eastern User Locale English (Canada) System Encoding ISO8859-1 Operating System SunOS 5.9 OS Architecture sparc Application Server Container WebLogic Server 8.1 SP2 Fri Dec 5 15:01:51 PST 2003 316284 Database type mssql Database JNDI address JiraDS

I have the default Character Encoding as UTF-8, but this renders ‘smart quotes’ as question marks. I tried changing it to UTF-16 but then JIRA would not display anything except question marks or blanks. I had to go into the database and update the properties table and restart JIRA to get it up and running again.
According to this link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;232580
Microsoft doesn't support UTF-8
According to this link:
http://www.microsoft.com/globaldev/DrIntl/columns/021/default.mspx#Q3
UTF-16 is the appropriate substitute, which is also supported by JIRA, according to this link from your documentation:
http://java.sun.com/j2se/1.3/docs/guide/intl/encoding.doc.html

So, how do I configure my application properly for MS SQL Server?

is related to

JRASERVER-1936 Character conversion errors

JRASERVER-8918 When copy-paste from word, quotes and double quotes appears as their unicode presentation in html

was cloned as

JRASERVER-8371 Inserting curly, smart quotes are not handled correctly