Loading...

XML

Word

Printable

Details

Type: Suggestion
Resolution: Fixed
Fix Version/s: None
Component/s: Documentation - All
Labels:
- affects-server

Feedback Policy:

We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

Description

NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

In Connecting JIRA to SQL Server 2008 documentation, it is said that the database collation type has to be case-insensitive SQL_Latin1_General_CP437_CI_AI. But in other products, such as Stash and Confluence, it has to be case-sensitive SQL_Latin1_General_CP1_CS_AS.

This setting could lead to problem during installation, upgrade and/or startup. Related JAC ticket: ~~JRA-21506~~, ~~JRA-37538~~.

Is there any particular reason we have case insensitive for JIRA and all the other products are case sensitive? We want to double check that it's correct - thanks.

Attachments

Issue Links

is caused by

JRASERVER-31054 It should be possible to run MS-SQL with case sensitive collations

Closed

is related to

JRASERVER-42503 Recommended Collation for SQL Server Database

Closed

relates to

JRACLOUD-39499 Verify JIRA Documentation regarding SQL Server Collation Type

Closed

mentioned in: Page Loading...; Page Loading...; Page Loading...

(1 mentioned in)

Activity

People

Assignee:: Wazza

Reporter:: Daniel Watania (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 12/Aug/2014 6:36 AM

Updated:: 19/Sep/2019 6:06 AM

Resolved:: 06/Sep/2015 11:53 PM