Horton

char(0)

Susanne Ebrecht <susanne@2ndquadrant.com>

View thread View on postgr.es
From: Susanne Ebrecht <susanne@2ndQuadrant.com>
To: Pg Bugs <pgsql-bugs@postgresql.org>
Date: 2011-10-17T07:31:46Z
Lists: pgsql-bugs 
Hello,

I couldn't find that somebody already mentioned it.

PostgreSQL isn't supporting CHAR(0).

An empty string has a length of 0.

CHAR(0) can have two values: NULL and empty string.

In MySQL it is very common to simulate not null boolean
by using CHAR(0).

This is a little bit annoying on migration topics.

Susanne

-- 
Susanne Ebrecht - 2ndQuadrant
PostgreSQL Development, 24x7 Support, Training and Services
www.2ndQuadrant.com