search

microsoft / vscode-postgresql

PostgreSQL extension for VSCODE
Other
393 stars 50 forks source link

Encoding error when result set contains non-ascii character #59

Closed korompaiistvan closed 1 year ago

korompaiistvan commented 4 years ago

Steps to Reproduce:

  1. Run a query in which the result set contains a non-ascii character. e.g. 'ä' The following query is enough to produce the error: select 'ä'

  2. Receive the following error:

    Started executing query at Line 1

Commands completed successfully 

Unhandled exception while executing query: 'ascii' codec can't encode character '\xe4' in position 8: ordinal not in range(128) 

Total execution time: 00:00:00
swjain23 commented 4 years ago

@korompaiistvan - This issue has been fixed. Can you check on your end?

cconrad commented 3 years ago

I just installed the extension and also experience this issue. Any help would be appreciated. I tried changing the client encoding with the SQL command "SET CLIENT_ENCODING TO 'Unicode';", but it did not help.