WARNINNG!!!!!
In this version (8) I can't see all the field using special char such as [ and ]
ex: Vout_[V]
Mysql permit the use of special char using '' to indicate the field...
Best regards
special cher error
I connect HeidiSQL to my database, I choose a table,
and I see the query show create table with only the field that havent in the field name special char.
I press 'data' to see the value
I can't see all the field using special char in the name of field,
I see the field called Vout, I don't see the field called Vout_[V]
and I see the query show create table with only the field that havent in the field name special char.
I press 'data' to see the value
I can't see all the field using special char in the name of field,
I see the field called Vout, I don't see the field called Vout_[V]
Got it. All of these chars are disallowed as they are used for quoting identifiers, either in MySQL or in MSSQL: `"[]
Here's the report from a user which had square brackets as quote chars.
If I were your boss I would shoot you to the moon for using square brackets in table column namesBut I guess I can use a server specific list of quote chars in the regular expression I use for parsing the SHOW CREATE TABLE output.
Here's the report from a user which had square brackets as quote chars.
If I were your boss I would shoot you to the moon for using square brackets in table column namesBut I guess I can use a server specific list of quote chars in the regular expression I use for parsing the SHOW CREATE TABLE output.
Code modification/commit
8dd4399
from ansgar.becker,
11 years ago,
revision 8.0.0.4397
Introduce server specific quote characters, so ParseTableStructure() and DeQuoteIdent() do not remove too much.
* bug report: http://www.heidisql.com/forum.php?t=12685
* broken in r4368, for fixing issue #2496
Please login to leave a reply, or register at first.