I have seen similar problems when the connections charset is set to none
when the DDL was executed and to a specific charset (eg UNICODE_FSS) for
the ems application. I usually take great care to use the correct
connection charset from the beginning and keep it the same on all my
application that access this database after I stumbled on this.

Let me assert at this point that I think the problem surfaces only when
the ddl is executed with charset = none in any other case it shouldn't.

>
> Below, the DDL command used to build the table.
> CREATE TABLE RH_CARGOS (
> ID_CARGO INTEGER NOT NULL,
> DESCRICAO VARCHAR(70) CHARACTER SET WIN1252 DEFAULT '' NOT NULL
> COLLATE WIN1252,
> STATUS INTEGER NOT NULL,
> CARGO_SEM_DETALHE INTEGER NOT NULL,
> TIPO_CARGO INTEGER NOT NULL,
> ACESSO_APPS INTEGER NOT NULL);
>
> As you can see, no reserved word, and so, no reason for using any kind
> of quotes (so I believe) for the table words (this same DDL command
> was used in another DB and and build and brought me the table correctly).
>
>
> ________________________________
> From: Lester Caine <lester@... <mailto:lester%40lsces.co.uk>>
> To: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> Sent: Wednesday, August 15, 2012 8:53 AM
> Subject: Re: ***SPAM*** [firebird-support] Not visible columns
>
> Tupy... nambá wrote:
> > I have a table whose columns are showed as not existing, at
> designers (as at EMS SQL Studio or ErWin) and also at the DDL comands
> for the table. But if you execute a SELECT command on it, it list all
> existing columns, and their data.
> >
> > For your delight, I send pictures showing the situation.
>
> Without the picture it's a little difficult to comment, but I'd go for
> there
> being a problem with the use or no of double quotes around the field
> name.
> Either a reserved word which the designers automatically wrap, but
> then may not
> be visible if the table's column was not defined with double quotes. Or
> alternatively something case sensitive which would also need to be
> wrapped properly.
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk/
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk/
> Rainbow Digital Media - http://rainbowdigitalmedia.co.uk/
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org/ and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com/
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]