Subject | RE: [firebird-support] Corrupted data FB 1.5 |
---|---|
Author | RB Smissaert |
Post date | 2009-12-30T22:43:33Z |
Have tested this now in a database and found that a chr(0) in the text
cannot cause this behaviour as it won't then show the bit
after the chr(0) in either application. In VB this was tested by doing an
update of a table field with the string:
"123" & chr(0) & "567"
So, there has to be something else going on or it has to be a different
character to cause the trouble.
RBS
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of RB Smissaert
Sent: 30 December 2009 19:56
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Corrupted data FB 1.5
Thanks, that is a really useful tip, as for now binary zero is the only
thing I can think of causing this problem, and it
seems ODBC/ADO (classic VB ADO) can't look beyond that. It is not in fact my
database that has this problem, but
one of my customers, so I will pass him this tip and report back what
happened.
RBS
_____
From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
[mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com] On Behalf Of Ivan Prenosil
Sent: 30 December 2009 19:18
To: Firebird-Support
Subject: Re: [firebird-support] Corrupted data FB 1.5
this way
SELECT * FROM ADDRESS
WHERE ADDRESS_LINE_3 CONTAINING CAST('' AS CHAR(1) CHARACTER SET OCTETS)
Ivan
http://www.volny <http://www.volny
<http://www.volny.cz/iprenosil/interbase/> cz/iprenosil/interbase/>
cz/iprenosil/interbase/
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
cannot cause this behaviour as it won't then show the bit
after the chr(0) in either application. In VB this was tested by doing an
update of a table field with the string:
"123" & chr(0) & "567"
So, there has to be something else going on or it has to be a different
character to cause the trouble.
RBS
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of RB Smissaert
Sent: 30 December 2009 19:56
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Corrupted data FB 1.5
Thanks, that is a really useful tip, as for now binary zero is the only
thing I can think of causing this problem, and it
seems ODBC/ADO (classic VB ADO) can't look beyond that. It is not in fact my
database that has this problem, but
one of my customers, so I will pass him this tip and report back what
happened.
RBS
_____
From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com
[mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com] On Behalf Of Ivan Prenosil
Sent: 30 December 2009 19:18
To: Firebird-Support
Subject: Re: [firebird-support] Corrupted data FB 1.5
> Have a case of a FB 1.5 (Classic) database on Windows where certainrecords
> in two fields of one table show fine in one application, but showtruncated
> in another, that is only the first 4 characters show. First applicationrecords.
> accesses the database via the API and the second via ODBC.
>
> This is the schema of that table:
>
> CREATE TABLE ADDRESS(
> ADDRESS_ID INTEGER NOT NULL,
> ADDRESS_LINE_1 VARCHAR(40),
> POSTCODE CHAR(10),
> UPDATED_DATE INTEGER,
> ADDRESS_LINE_2 VARCHAR(40),
> ADDRESS_LINE_3 VARCHAR(40),
> ADDRESS_LINE_4 VARCHAR(40),
> ADDRESS_LINE_5 VARCHAR(40))
>
> The problem shows in ADDRESS_LINE_3 and ADDRESS_LINE_4, but only in a few
> records.
> ADDRESS_LINE_2 has an index, but ADDRESS_LINE_2 hasn't.
>
> The question is how to figure out what is wrong with the particular
> My guess is that somehow wrong charactersIf the problem is caused by binary zero in your data, you can find such rows
> got into the text, maybe Chr(0), but I can't see it in my programming
> environment, which is VB.
> Is there a way with SQL to see what might be the trouble here?
this way
SELECT * FROM ADDRESS
WHERE ADDRESS_LINE_3 CONTAINING CAST('' AS CHAR(1) CHARACTER SET OCTETS)
Ivan
http://www.volny <http://www.volny
<http://www.volny.cz/iprenosil/interbase/> cz/iprenosil/interbase/>
cz/iprenosil/interbase/
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]