> 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.
Hard to believe ;)
> 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.
Try this: field CONTAINING ASCII_CHAR(0)
> (We have still not made tests with defining UTF-8 as the DB
> character set.)
The most quick way to research the issue is to provide me with database
or backup. You can drop all not related objects and obfuscate all important
data.
Regards,
Vlad
------------------------------------------------------------------------------
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
