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
