Re:Re: Re: Does psqlodbc_11_01_0000-x64 support special characters?

Thank you for the information.

After testing, I found that I only need to escape the following 7 characters.

% → %25

" → %22

' → %27

+ → %2B

; → %3B

= → %3D

{ → %7B

At 2022-10-13 13:27:16, "Jeffrey Walton" <noloader(at)gmail(dot)com> wrote:
>On Thu, Oct 13, 2022 at 12:13 AM gzh <gzhcoder(at)126(dot)com> wrote:
>>
>> My PostgreSQL is deployed on Amazon RDS, so the password of PostgreSQL is random and has various reserved characters.
>>
>> I don't know if the reserved characters below are complete, and there are some characters (e.g. * , $) I tried without problems.
>>
>> Could you tell me which characters require percent-encoding for PostgreSQL password?
>>
>>
>> space → %20
>>
>> ! → %21
>>
>> " → %22
>>
>> # → %23
>>
>> $ → %24
>>
>> % → %25
>>
>> & → %26
>>
>> ' → %27
>>
>> ( → %28
>>
>> ) → %29
>>
>> * → %2A
>>
>> + → %2B
>>
>> , → %2C
>>
>> - → %2D
>>
>> . → %2E
>>
>> / → %2F
>>
>> : → %3A
>>
>> ; → %3B
>>
>> < → %3C
>>
>> = → %3D
>>
>> > → %3E
>>
>> ? → %3F
>>
>> @ → %40
>>
>> [ → %5B
>>
>> \ → %5C
>>
>> ] → %5D
>>
>> ^ → %5E
>>
>> _ → %5F
>>
>> ` → %60
>>
>> { → %7B
>>
>> | → %7C
>>
>> } → %7D
>>
>> ~ → %7E
>
>https://www.rfc-editor.org/rfc/rfc3986#section-2.2
>
>Jeff