Error connecting to redshift server

microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases

Other

198 stars 37 forks source link

Error connecting to redshift server #440

Open tj-vishwas opened 1 year ago

tj-vishwas commented 1 year ago

Describe the bug I am getting the following error while connecting to redshift server through azure data studio using the postgresql extension. codec not available in Python: 'UNICODE'

I am using the following values when connecting to the server:

Expected behavior It should create a connection and should be available in my connection directory of azure data studio.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop:

OS: Windows 11

ADS: Version: 1.44.1 (system setup) Commit: 8f53a316fa00a98264f1ab119641cd540b5af25c Date: 2023-06-01T02:12:48.765Z VS Code: 1.70.0 Electron: 19.1.8 Chromium: 102.0.5005.167 Node.js: 16.14.2 V8: 10.2.154.15-electron.0 OS: Windows_NT x64 10.0.22621

Dalran commented 1 year ago

@tj-vishwas There is a work around using the PG environment variables for this. Set a user or system environment variable called "PGCLIENTENCODING" to utf-8 and restart azure data studio. This will get you past this error for the time being.

tj-vishwas commented 1 year ago

@Dalran can you tell me where is this to be added? I ran SET PGCLIENTENCODING=utf-8 in powershell but no luck. I also tried setting Client Encoding to utf-8 in the advanced tab but again no luck. Could you please help where is this to specified?

distinctdan commented 4 months ago

I'm also experiencing this issue, which is a shame because ADS looks like a nice product.

rgbattersby-55 commented 4 months ago

Experiencing the same issue. Are there any updates? I am using Azure Data Studio on OSX 14.5.

mattcrites commented 2 months ago

@Dalran can you tell me where is this to be added? I ran SET PGCLIENTENCODING=utf-8 in powershell but no luck. I also tried setting Client Encoding to utf-8 in the advanced tab but again no luck. Could you please help where is this to specified?

For anyone unsure on where to add the environment variable, you can do it from the Windows Control Panel:

JSullivan-Arcadia commented 1 month ago

For anyone unsure on where to add the environment variable, you can do it from the Windows Control Panel:

I'm experiencing this. Win11, Azure Data Studio v1.49.1 @mattcrites I can confirm this works. However, while I can now query the database, I can't see the schemas.

haseeb4091 commented 10 hours ago

Thanks for the workaround, Azure please fix this issue, some time we cannot do this workaround on client pc