Subject Re: [firebird-support] I need to know where this field renaming occur? And this should be possible?
Author Mark Rotteveel
On Tue, 22 Jan 2013 13:06:48 -0000, "karolbieniaszewski"
<liviuslivius@...> wrote:
> Hi,
>
> I need to know where this field renaming occur?
> I suppose that this is driver specific action but maybe this is done by
> server?
>
> select RDB$CHARACTER_SET_NAME, CAST(1 AS INTEGER) AS
> RDB$CHARACTER_SET_NAME FROM RDB$DATABASE
>
> if i use dbexpress i see result
>
> RDB$CHARACTER_SET_NAME, RDB$CHARACTER_SET_NAME_1 // "_1"
>
> in flamerobin i see
> RDB$CHARACTER_SET_NAME, RDB$CHARACTER_SET_NAME
>
> this should be possible at all or this ambigous namin should be
restricted
> by server

Most likely DB Express does this when displaying the columns, multiple
columns with the same name are allowed by Firebird (and the SQL standard).

Mark