Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Warning in psql console on Windows for none matching character encoding #83

Open
Eprince-hub opened this issue Jul 12, 2024 · 0 comments
Assignees
Labels

Comments

@Eprince-hub
Copy link
Member

Eprince-hub commented Jul 12, 2024

Related to #76

There is a warning in the psql console about character encoding that doesn't match the system encoding. Some Windows machines still use the legacy 1252 that may not support all utf-8 character encoding.

The warning from the psql console

WARNING: Console code page (850) differs from the Windows code page (1252). 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details.

Recommended Solution

  • Set the Windows character encoding from 1252 to utf-8

Not Recommended Solution

  • Set the character encoding in psql to 1252 (This may be setting the psql to use a legacy character encoding)

Some findings

SHOW client_encoding;

client_encoding
-----------------
 UTF8
(1 row)

Checking the system info with [System.Text.Encoding]::Default
System info before the checkbox is checked

IsSingleByte      : True
BodyName          : iso-8859-1
EncodingName      : Western European (Windows)
HeaderName        : Windows-1252
WebName           : Windows-1252
WindowsCodePage   : 1252
IsBrowserDisplay  : True
IsBrowserSave     : True
IsMailNewsDisplay : True
IsMailNewsSave    : True
EncoderFallback   : System.Text.InternalEncoderBestFitFallback
DecoderFallback   : System.Text.InternalDecoderBestFitFallback
IsReadOnly        : True
CodePage          : 1252

System info after the checkbox is checked (all 1252 changed to utf-8 and its 65001 number equivalent)

BodyName          : utf-8
EncodingName      : Unicode (UTF-8)
HeaderName        : utf-8
WebName           : utf-8
WindowsCodePage   : 1200
IsBrowserDisplay  : True
IsBrowserSave     : True
IsMailNewsDisplay : True
IsMailNewsSave    : True
IsSingleByte      : False
EncoderFallback   : System.Text.EncoderReplacementFallback
DecoderFallback   : System.Text.DecoderReplacementFallback
IsReadOnly        : True
CodePage          : 65001

Conversation in #80 about this

60ddd09#r1668603246
60ddd09#r1674257929

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant