Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can we define collation type at database, rather than server, for FishEye

We're just finishing an evaluation of FishEye (really good product) and am looking at agreeing the final resting place for the database, aiming for MS Sql Server.

Our SQL Servers normally use "Latin1_General_CI_AS" collation, whereas FishEye needs "Latin1_General_CS_AS".

Are we best creating a new server instance for "Latin1_General_CI_AS", or are we able to get away with creating a database with "Latin1_General_CI_AS" collation only?

Probably the first I suspect ...

1 answer

1 accepted

1 vote
Answer accepted

Hi Tim,

For your reference, the server requirement for the Fisheye and MSSQL are as mentioned here. As mentioned in the requirement, Your database server must be configured to use the Latin1_General_CS_AS collation set. The following collation type can be set at the database level instead of setting to the whole server and interrupting other database instances within your MSSQL Server.

Thankyou. We've concluded that we'll create a new SQL Server instance with the correct collation type, rather than define at the database. Just to ensure we do not hit any problems in future.

Thanks

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Bitbucket Smart Commits vs. Genius Commits - What's the difference?

If you already heard about Smart Commits in Bitbucket, know that you just stumbled upon something even better (and smarter!): Genius Commits by Better DevOps Automation for Jira Data Center (+ Server...

106 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you