database - Openedge progress - Can't escape single quote - Is this a bug? -

database - Openedge progress - Can't escape single quote - Is this a bug? -

i trying run simple query on jdbc alter table client alter \"cust-name\" set pro_description 'customer name' works well. but, when have set description "customer's name", i.e, include single quote - unable work.

i tried

alter table client alter \"cust-name\" set pro_description 'customer~'s name' alter table client alter \"cust-name\" set pro_description 'customer~~'s name' alter table client alter \"cust-name\" set pro_description 'customer\\'sname' alter table client alter \"cust-name\" set pro_description "customer's name"

nothing works.

i don't know progress, sql standard duplicate single quote:

'customer''s name'

database openedge progress-db