Re: [pgAdmin][RM5210] pgAdmin4 silently truncates text larger thanunderlying field size

import psycopg2
try:
    conn = psycopg2.connect("dbname='postgres' user='postgres' host='XXX.XXX.XXX.XXX' password='test' port=5432")
    cur = conn.cursor()
    cur.execute("UPDATE public.account SET username = %(username)s::character varying(5) WHERE user_id = 1;", {"username": "username-test-123"})
    cur.execute("COMMIT;")
except Exception as e:
    print('Exception : {0}'.format(e))

Output:

It will save the record with 5 char data without any error.

psql output:

postgres=# select * from public.account;
 user_id | username 
---------+----------
       1 | usern
(1 row)

Scenario 2:  Query with only data type 
import psycopg2
try:
    conn = psycopg2.connect("dbname='postgres' user='postgres' host='XXX.XXX.XXX.XXX' password='test' port=5432")
    cur = conn.cursor()
    cur.execute("UPDATE public.account SET username = %(username)s::character varying WHERE user_id = 1;", {"username": "username-test-123"})
    cur.execute("COMMIT;")
except Exception as e:
    print('Exception : {0}'.format(e))
Output:
Exception : value too long for type character varying(5)
data will not save in the table.
Scenario 3:  Query without data type
import psycopg2
try:
    conn = psycopg2.connect("dbname='postgres' user='postgres' host='XXX.XXX.XXX.XXX' password='test' port=5432")
    cur = conn.cursor()
    cur.execute("UPDATE public.account SET username = %(username)s WHERE user_id = 1;", {"username": "username-test-123"})
    cur.execute("COMMIT;")
except Exception as e:
    print('Exception : {0}'.format(e))
Output:
Exception : value too long for type character varying(5)
again data will not save in the table.
These are some different behaviours with psycopg2. So to complete this patch which apporach should I follow? or any new approach is also welcome.
Thanks!