We have in the meantime made the following test:

- copied DB to another machine (always under VB 2.1.4) and
on that machine:

- validate => Error

- dropped a number of fields, but did not change primary
index definition in any way. The original table was
described in one of my previous messages. The resulting
table is:

CREATE TABLE MATBEW(
  MSEG_MATNR Varchar(18) NOT NULL,
  MSEG_WERKS Varchar(4) NOT NULL,
  MSEG_LGORT Varchar(4) NOT NULL,
  MSEG_MBLNR Varchar(10) NOT NULL,
  MSEG_MJAHR Varchar(4) NOT NULL,
  MSEG_ZEILE Varchar(4) NOT NULL,
  MSEG_BWART Varchar(3),
  MSEG_SHKZG Varchar(1),
  MSEG_SOBKZ Varchar(1),
  MSEG_MENGE Double precision,
  MKPF_BUDAT Date,
  MSEG_LIFNR Varchar(10),
  MSEG_KUNNR Varchar(10),
  CONSTRAINT MATBEW_PK PRIMARY KEY 
(MSEG_MATNR,MSEG_WERKS,MSEG_LGORT,MSEG_MBLNR,MSEG_MJAHR,MSEG_ZEILE));

- backup
- restore
- validate => OK!!!

It seems as if the fields that do not have anything to do
with index are influencing the index build up.

We would like to make a definitive check if in any of our
string fields zero byte values are occurring (h00), since
Vlad has asked about this and I couldn't completely dismiss
that possibility.

Please help: How can I check if a string field value
includes at least one zero byte - I would like to write a
SELECT statement using these checks, but have no clue how.

(We have still not made tests with defining UTF-8 as the DB
character set.)

Thank you.
Borut


------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to