How to Change collate & ctype for an existing database?

[Daulat Ram]

Hi,

How we can change the   Collate &  Ctype from "c"  to  "C.UTF-8" on existing 
production database.

SELECT datcollate FROM pg_database WHERE datname='wwkidbt';

datcollate

------------

C
postgres=# select version();
                                                 version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.5.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 
5.3.1-14ubuntu2) 5.3.1 20160413, 64-bit



Please advice about the below method:

update pg_database set datcollate='C.UTF-8', datctype='C.UTF-8'  where 
datname='wwkidbt';

Is there any impact on data/corruption if we do via update command ?

Thanks,

Daulat