Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug

Getting error collation not supported while changing data type.

To Reproduce

Steps to reproduce the behavior:

1. Create a table with column having data type 'character varying'
2. Now try to edit data type to "Char" data type.
3. Click on save. Error is shown.
4. Issue is for both foreign tables and normal tables.

Expected behavior

Create correct the sql so that data type can be changed.
It should be alter column <column_name> type "char".
Also when issue is fixed add a test case in API tests for the same.

Screenshots