1. Ng Chuen Seng
  2. PowerServer
  3. Tuesday, 4 May 2021 05:48 AM UTC

With PowerClient postgresql 12 citext extensions works fine but not with PowerServer 2021 beta.

Any clue?

Accepted Answer
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 4 May 2021 06:19 AM UTC
  2. PowerServer
  3. # Permalink

Please open a support ticket and attach your test case to the support ticket.  Thanks.

Comment
There are no comments made yet.
Ng Chuen Seng Accepted Answer Pending Moderation
  1. Thursday, 6 May 2021 09:02 AM UTC
  2. PowerServer
  3. # 1

Hi Julie,

Got it. Thank you very much for the prompt reply.

 

Comment
There are no comments made yet.
Julie Jiang @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 May 2021 07:27 AM UTC
  2. PowerServer
  3. # 2

Hi Ng Chuen Seng,

Please add the disablebind setting in DBParm. For example, 

SQLCA.DBParm = "ConnectString='DSN=en_post52u;',disablebind=1"      

This setting allows you to query for columns in a case-insensitive manner.

Best regards, Julie

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.