special cher error

[expired user #6966]'s profile image [expired user #6966] posted 11 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 11 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.
[expired user #6966]'s profile image [expired user #6966] posted 11 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]
ansgar's profile image ansgar posted 11 years ago Permalink
Understand. Will check that.
ansgar's profile image ansgar posted 11 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, 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
ansgar's profile image ansgar posted 11 years ago Permalink
Fixed in r4397
[expired user #6966]'s profile image [expired user #6966] posted 11 years ago Permalink
OK, Fixed correctly in r4401

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