Comments
-
Also can I ask what cloud platform your cloud service runs on? At this point we're thinking of switching to AWS RDS MYSQL for our Jira db. I know your cloud runs postgresql so wondering what cloud vendor you use or if you host it yourself?
-
Below is from AWS RDS support as it appears you can't change the collation for postgresql but seems you have more options for mysql the underlying Linux OS of RDS cannot be modified On RDS mysql db instance the below collation settings can be changed and they are @ a global level character_set_client = utf8…
-
hah I already did that and you seems you can't change collation was hoping you knew of a way or could test it out as RDS is very popular
-
Shannon is this the setting you're recommending changing? client_encoding if so I changed it to POSIX.UTF-8 but the sql still returns en_US.UTF-8
-
also for AWS RDS I don't believe you can run set commands as they're configured in parameter groups. I can't seem to find the parameter to change collation so was hoping someone else has experienced this already.
-
here's the output of the select jiraprod=> SELECT datcollate jiraprod-> FROM pg_database jiraprod-> WHERE datname = Current_database(); datcollate ------------- en_US.UTF-8 (1 row)
