I use this script to create the database:
DROP DATABASE tei;
CREATE DATABASE tei
WITH ENCODING='iso_8859_7'
OWNER=anakreon
TEMPLATE=template1
The encoding of the database is iso_8859_7.
--
Three words describe our society:homo homini lupus
---(end of broadcast)
PROTECTED]
Sent: Sat 3/4/2006 9:46 AM
To: Jim Nasby
Cc:
Subject:Re: [GENERAL] Insert fails when it shouldn't
To execute the insert statements I use psql.
From the command line the command \encoding
writes:ISO_8859_7 which is the right one
since characters are greek st
What encoding did you initdb with?
On Thu, Mar 02, 2006 at 04:59:39PM +0200, Anakreon Mendis wrote:
> The table:
> CREATE TABLE DILOSIS (
> DL_AEM INT NOT NULL,
> DL_CODE VARCHAR(6) NOT NULL,
> DL_YEAR INT NOT NULL,
> DL_GRADE FLOAT(3) NOT NULL,
> DL_LESTYPE INT NOT N
The table:
CREATE TABLE DILOSIS (
DL_AEM INT NOT NULL,
DL_CODE VARCHAR(6) NOT NULL,
DL_YEAR INT NOT NULL,
DL_GRADE FLOAT(3) NOT NULL,
DL_LESTYPE INT NOT NULL,
DL_SEMESTER INT NOT NULL,
DL_DM INT NOT NULL,
DL_COEF FLOAT(3), --Syntelesti
