Subject | Re: [firebird-support] I need to know where this field renaming occur? And this should be possible? |
---|---|
Author | Mark Rotteveel |
Post date | 2013-01-22T13:11:39Z |
On Tue, 22 Jan 2013 13:06:48 -0000, "karolbieniaszewski"
<liviuslivius@...> wrote:
columns with the same name are allowed by Firebird (and the SQL standard).
Mark
<liviuslivius@...> wrote:
> Hi,restricted
>
> 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
> by serverMost likely DB Express does this when displaying the columns, multiple
columns with the same name are allowed by Firebird (and the SQL standard).
Mark