Hello

I tried to create a table with some

CHARACTER VARYING(10480000) CHARACTER SET UTF8

column in PostgreSQL 8.3 (I have the latest version) and
whatever I try it would not work with the CHARACTER SET
specification in the column data type (UTF8, UTF-8, 'UTF8',
'UTF-8', "utf-8", etc...) . It complains about something
like unknown column varchar_utf8 in some system table.

I find this a little strange, if not hard to believe.

Is PostgreSQL really not supporting a character set
specification in a character column's data type or am I
missing somenthing ?

Is there more documentation about ISO compatibility for
PostgreSQL ? I mean about the support for ISO/IEC 9075:1999
(SQL3) in PostgreSQL ?

I know it's offtopic but does anyone know about some more
free DBMSs that I could install and try to see how much of the
SQL standard they support ?

Thank you,
Timothy Madden

Timothy Madden wrote on 19.04.2009 22:14:
pretty obvious when looking at the manual btw)

Thomas

Timothy Madden schrieb:
There is Firebird, which definitely supports character set
specifications in column definitions, but, from the Firebird Book, p.
347: "Firebird's SQL language adheres closely to the SQL-92 standards
(ISO/IEC 9075:1992) at entry level. Firebird 1.5 introduced a number of
features in accordance with the more recently released SQL-99 standard.
Although Firebird SQL follows standards closely, there are small
differences."

There is MySQL, which certainly did not "follow standards closely" in
former versions. I don't know how far they have changed that.

There is OCELOT, which is on the CD-ROM of my (german) SQL textbook,
because it's said to be completely standard (? is that possible?), but I
don't know anything else about it and didn't try it.

I'm very certain there are more, probably much more.

HTH
Sibylle