How deeply does PostgreSQL Mistakes and How to Avoid Them cover encoding?

Explains byte-level failures, legacy MySQL encodings, conversion, null-byte cleanup, and locale configuration.

Encoding

As explained in PostgreSQL Mistakes and How to Avoid Them

A character encoding maps textual characters to coded representations such as bytes for storage and processing.

Character encoding maps textual characters to coded representations such as bytes. During a MySQL or MariaDB migration, assuming standard SQL compatibility can hide incompatible encodings and corrupt imports. section 10.3

Diagnosing an encoding mismatch

A PostgreSQL import can fail with `invalid byte sequence for encoding "UTF8": 0xe9` when a dump retains MySQL's latin1 bytes for é. Convert the dump with `iconv -f latin1 -t utf8` before retrying the import. section 10.3

Encoding problems can continue after byte conversion:

MySQL's historical `utf8` supports only three-byte characters, whereas `utf8mb4` supports four-byte Unicode characters, including characters the older implementation cannot encode. section 10.3

How PostgreSQL Mistakes and How to Avoid Them covers it

Cover of PostgreSQL Mistakes and How to Avoid Them

liveBook manning.com

Read PostgreSQL Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

Modern C
liveBook manning.com

Grokking Algorithms, Second EditionA character encoding is a system that represents text characters as binary code values.
liveBook manning.com

Deep Learning with PyTorch, Second EditionA tokenizer function that converts text into numeric token representations.
liveBook manning.com

Modern C, Third EditionAn encoding is a mapping or representation that associates data values with character or textual forms.
liveBook manning.com

The Quick Python Book, Fourth Editionencode is a string method that converts text into a bytes object using a character encoding.
liveBook manning.com

Grokking AI Algorithms, Second EditionText encoding is the conversion of written language into numerical representations that a computer model can process.
liveBook manning.com

Go in Practice, Second Edition
liveBook manning.com

Rust in Action: Systems programming concepts and techniquesAn encoding is a representation that maps information such as instructions or data to a defined sequence of symbols or bits.

Compare how 9 books explain encoding →

Related concepts

UTF-8includes · UTF-8 is a variable-width Unicode encoding that represents each Unicode scalar value using one to four bytes and preserves ASCII byte representations.
latent spaceproduces · A latent space is a learned representational space in which numerical coordinates encode information or features inferred from observed data.
PasswordEncoderpart of · PasswordEncoder is a Spring Security interface and strategy for encoding passwords and verifying supplied passwords against stored encoded representations.
stringused by · A string is a programming-language value representing an ordered sequence of characters or character units as text.
security through obscurityused by · Security through obscurity is a security approach that relies on concealing system designs, implementations, or configurations to impede attacks.

This explainer was generated by Manning's knowledge graph from the text of PostgreSQL Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.