Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #9995 (closed)

Opened 11 years ago

Closed 8 years ago

Docs:Users should be encouraged to use UTF8 for the DB

Reported by: jamoore Owned by:
Priority: major Milestone: Unscheduled
Component: Documentation Version: OMERO-5.2.0
Keywords: n.a. Cc: pwalczysko, jburel, rleigh, ajpatterson, hflynn, rkferguson
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.

Description

In PR 171 Andrew fixed the unix text install instructions for PostgreSQL to use UTF8 rather than ASCII. This was brought up on the forums - https://www.openmicroscopy.org/community/viewtopic.php?f=5&t=3598

We need to make clear across the board (and on the FAQ?) that UTF-8 is preferred. The Windows instructions need to be similarly reviewed and possibly screenshots re-taken.

Further, Roger brought up the issue of locales and pointed at the docs on pg.org: http://www.postgresql.org/docs/9.2/static/locale.html

See https://chat.glencoesoftware.com/chatlogs/devteam/2012-12-04.html for the conversation:

[09:56:49] <rleigh> josh: They don't need to drop unless they really want UTF-8. Documenting this would be useful.  Additionally, when you do create with UTF-8, you also get the collation rules for that locale, so there may be differences depending upon the OS and locale in use here.
[09:57:29] <rleigh> E.g. on Debian, this defaults to the system locale (for my systems, that's en_GB.UTF-8, so I get the en_GB collation rules).

Change History (2)

comment:1 Changed 8 years ago by jamoore

  • Milestone changed from 5.x to Unscheduled

comment:2 Changed 8 years ago by sbesson

  • Resolution set to fixed
  • Status changed from new to closed
  • Version set to OMERO-5.2.0

Should be mandatory since OMERO 5.1.0.

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.65562 sec.)

We're Hiring!