Hi there,
I migrated Jira 6.1.x (db=oracle;server) to 6.4.14(postgres) to 7.13(postgres) and after install i got the warning 'unsupported collation'. We use en_US.TF-8 for DB
I therefore migarted the DB to a new DB with Collation C.
CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
But is it really necessary if we do not use Amazon AWS RDS?
Could there be a Problem with umlauts äöü with Collation C?
Or is a other collation better?
Thanks, kind regards
You should follow the character set recommendations in the Jira database setup guide for your database technology. This is what is tested and supported. At best, everything will work properly and you get the nag message every time you log in when you use an unsupported character set. I've seen cases where the collation is not set correctly and users have added content using characters not supported by the collation character set that have resulted in garbage being stored in the database and the data being lost. You really should use the correct character set collation.
Okay, i will do that!
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.