Support
Unicode and Timesheet

Journyx Timesheet version 8.0 and higher fully supports native Unicode storage in the database. This means user-entered text from different languages can be freely mixed on the same site. However only one "collation" (linguistic sort ordering in things like search results) can be used on a site. See below for collation details.

Earlier version of Timesheet such as version 7.9 have limited or no Unicode support.

Timesheet 8.0 and higher automatically uses Unicode on Microsoft SQL Server, Oracle, and the internally provided PostgreSQL database option. However when setting up an external PostgreSQL database connection, you will need to create the database with the "UTF8" (Unicode) character set as described in the external PostgreSQL setup instructions.

As mentioned above, only a single collation can be used on any given site. The collation determines the linguistic sort ordering of search results and similar things. The collation is determined during the external database setup. Please refer to the appropriate external database instructions for your platform for details. The collation for the internal database (the provided copy of PostgreSQL) is determined automatically based on your operating system language settings. Once it is set it cannot be changed without recreating the database environment.

In most cases a single collation combined with the Unicode universal character set will provide satisfactory results for most users.