Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

special cher error

epielettronica's profile image epielettronica posted 7 years ago in General Permalink
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
ansgar's profile image ansgar posted 7 years ago Permalink
Please don't cross-post!

Now, I don't get what you mean with "I can't see all the field using special char". Describe more detailed please.
epielettronica's profile image epielettronica posted 7 years ago Permalink
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]
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 7 years ago Permalink
Understand. Will check that.
ansgar's profile image ansgar posted 7 years ago Permalink
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 namessmileBut 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 from ansgar.becker, 7 years ago, revision 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
ansgar's profile image ansgar posted 7 years ago Permalink
Fixed in r4397
epielettronica's profile image epielettronica posted 7 years ago Permalink
OK, Fixed correctly in r4401

Please login to leave a reply, or register at first.