ErrorCode -607 when creating tables (Lazarus+Zeos+Firebird)

[Tommi]

I'm using firebirdd-2.0 protocol (but I tried also with 1.5), Zeos 6.5.1 and Lazarus 0.9.24.

This is my code:

Code: Select all

procedure TForm1.Button2Click(Sender: TObject);
begin
  ZConnection1.User:='sysdba';
  ZConnection1.Password:='masterkey';
  if not ZConnection1.Connected then
  begin
   ZConnection1.Database := 'db1.fdb';
   ZConnection1.Connect;
   if ZConnection1.Connected then showmessage('Connesso');
  end;
  ZQuery1.Connection:=ZConnection1;
  try
    ZQuery1.SQL.Clear;
    ZQuery1.SQL.Add(edit2.text);
    ZQuery1.ExecSQL;
  except
   on E : EZSQLException do
   begin
//     zconnection1.Rollback;
     ShowMessage('ErrorCode : ' + IntToStr(EZSQLException(E).ErrorCode)+'  '+EZSQLException(E).StatusCode );
   end;
  end;
  ZQuery1.SQL.Clear;
end;

When I put in my listbox:" create table MyTable(col1 integer, col2 integer)" it works succesfully, but if I try to create a table with a varchar field "create table MyTable(col1 integer, col2 varchar(20))" it returns 'ErrorCode -607'.

Can somebody help me ?

Thank you

[Tommi]

Probably I discovered what happened, using TZSQLMonitor I received this message:

2008-07-11 20.07.09 cat: Transaction, proto: firebirdd-2.0, msg: unsuccessful metadata update PROV2 CHARACTER SET ISO8859_1 is not installed, errcode: -607, error: This operation is not defined for system tables.

How can I install ISO8859_1 CHARACTER SET ?

Thank you