Skip to content

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

Description

@Eprince-hub

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions