-
Notifications
You must be signed in to change notification settings - Fork 18
Open
Labels
Description
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
1252to 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
- Character encoding 1252 is a legacy single-byte encoding
- The suggestions in Notes for Windows Users of Postgres don't work
- Some suggested solutions online don't persist after the terminal restart
client_encodingis already in UTF8 in psql but this doesn't solve the issue (I think the system and psql encoding need to match)
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 : 1252System 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 : 65001Conversation in #80 about this
karlhorky