Hello ,

I have a problem with some data not returning. I'm using Delphi 7,
IBO 4.9.14.2 and Firebird 2.5.

The query is as follows:

SELECT PRV.RDB$USER, PRV.RDB$GRANTOR, PRV.RDB$PRIVILEGE,
PRV.RDB$GRANT_OPTION, PRV.RDB$RELATION_NAME, PRV.RDB$FIELD_NAME,
PRV.RDB$USER_TYPE, PRV.RDB$OBJECT_TYPE, Cast(0 as integer) SRT
FROM RDB$USER_PRIVILEGES PRV

Most of the CHAR fields are UNICODE_FSS, but RDB$PRIVILEGE has a
charset of NONE.

I connect using a charset of ISO8859_1(which is the default
charset for the database).

When using TIB_Query, the value of RDB$PRIVILEGE is properly
retrieved. But, with TIBOQuery, the value is empty. And, I need to
use TIBOQuery, since it is used by another component(DB Comparer
version 3.2, from Clever Components).

Any ideas would be appreciated

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)