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

special cher error

epielettronica posted 1 year ago in General
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 posted 1 year ago
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 posted 1 year ago
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 posted 1 year ago
Understand. Will check that.
ansgar posted 1 year ago
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.

ansgar posted 1 year ago
Fixed in r4397
epielettronica posted 1 year ago
OK, Fixed correctly in r4401

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