isql -ex -u sysdba -p password localhost:<full path to my db>
Ertan,
if you only want to use it in selects, then make a computed field that refers to it and use that in selects.
András
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit
https://groups.google.com/d/msgid/firebird-support/CAH2i4yegjHEBXW2pc88ZxtwCnsy7D8cpbnO%2BnuRbidV5f51j6A%40mail.gmail.com.
I do not understand your problem.
Do you have tab character on your keyoard? If Yes press it, but in software wich do not replace it with spaces, eg. Use Notepad.
select "SELF_MENU_TABLE_PICKUP " FROM MYTABLE
Regards,
Karol Bieniaszewski
Od: Ertan Küçükoglu
Wysłano: sobota, 27 maja 2023 20:27
Do: firebird...@googlegroups.com
Temat: [firebird-support] Selecting a field with special characters
Hello,
I am provided a FirebirdSQL 2.5.9 database. It has a table with a column name including a TAB character. I didn't even know that FirebirdSQL allowed special characters (at least some of them) in column names until I received that database.
I used below command to extract whole database DDL
isql -ex -u sysdba -p password localhost:<full path to my db>
Here is what I see for that column in the exported file.
As it can be seen, the last character in the column name is a TAB character.
I need to select that column by name something like below
select "SELF_MENU_TABLE_PICKUP\t" from mytable
select "SELF_MENU_TABLE_PICKUP" || CHAR(9) from mytable
etc.
But I could not make it work using such escape characters in select statements .
Is there a way to actually include this column name in select other than adding tab character itself?
Thanks & Regards,
Ertan Küçükoğlu
--
Tim
Yes, exacly, tab character in column name, table name, whatever 😉
Email also replace tabs to space, so use some software which do not replace it, eg notepad, notepad++.
Regards,
Karol Bieniaszewski
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/3glfrmi8r3peir4tu1fmvqd9.1685222694987%40gmail.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4QTFZx2wTZz2K23x5%40smtp.poczta.onet.pl.