distal-attribute
distal-attribute
distal-attribute
distal-attribute

special cher error

User, date Message
Written by epielettronica
11 months ago
Category: General
4 posts since Thu, 23 May 13
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
Written by ansgar
11 months ago
4788 posts since Fri, 07 Apr 06
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.
Written by epielettronica
11 months ago
4 posts since Thu, 23 May 13
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]
Written by ansgar
11 months ago
4788 posts since Fri, 07 Apr 06
Understand. Will check that.
Written by ansgar
11 months ago
4788 posts since Fri, 07 Apr 06
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.
Written by ansgar
11 months ago
4788 posts since Fri, 07 Apr 06
Fixed in r4397
Written by epielettronica
11 months ago
4 posts since Thu, 23 May 13
OK, Fixed correctly in r4401
 

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