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

special cher error

User, date Message
Written by epielettronica
1 year 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
1 year ago
4940 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
1 year 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
1 year ago
4940 posts since Fri, 07 Apr 06
Understand. Will check that.
Written by ansgar
1 year ago
4940 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
1 year ago
4940 posts since Fri, 07 Apr 06
Fixed in r4397
Written by epielettronica
1 year ago
4 posts since Thu, 23 May 13
OK, Fixed correctly in r4401
 

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