Cannot find item "COLLATION" in collection of type TDAFieldCollection

Data Abstract
1

Hi,
I added a new connection in schema that is using MYSQLDAC driver. I got the following error message when I drop the table to “Tables”. How to solve it?

image

2

Hi,

Can you share your DDL for this table, pls?
You can drop email to support@ for keeping privacy.

3

Hi,
Are you received my email about DDL?

4

Hi,

No, I haven’t.
by other hand, you can send PM to support group.

5

Hi,
I PM to support group with attachment. Please check it. Thanks.

6

Hi,

I cannot reproduce this issue.

note: your DDL script doesn’t contain collation word.

7

Hi,
I guess it is not DDL script issue. It should be MySQL server issue. Collation control should be under MySQL server instead of tables. Am I right? I can’t change any setting in MySQL because it belongs to another software house solution.

8

Hi,

Try to create DDL script for whole DB.
Collation should be present when you create MySQL DB

9

Hi,
I used Navicat to check MySQL environment.
image

10

Hi,

Try to open this SQL inside Schema Modeler:

SELECT 
COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT, CHARACTER_MAXIMUM_LENGTH, 
CHARACTER_SET_NAME, COLUMN_KEY, COLUMN_COMMENT, EXTRA, COLUMN_TYPE, 
NUMERIC_PRECISION, NUMERIC_SCALE
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE 
(TABLE_NAME = "py2igmt") 
ORDER BY ORDINAL_POSITION

will preview contain COLLATION word in results?

11

Hi,
Where can execute the following SQL? I don’t know how to execute the following code.

12

Hi,

  • create connection to your DB
  • add a new table
  • add a new statement
  • set SQL mode and paste that sql

animation1

13

Hi,
I got the following error.
image

14

Hi,

odd.
this is standard MySQL table: MySQL :: MySQL 8.0 Reference Manual :: 26.3.8 The INFORMATION_SCHEMA COLUMNS Table

15

Hi,
Our new application vendor is using too old version of MySQL
image

16

Hi,

try to declare tables manually like
select fld1, fld2 from table where {WHERE}
looks like you can’t use AutoSQL for such outdated DB.

from https://www.mysql.com/support/eol-notice.html :

MySQL 4.0 Extended Support ends on December 31, 2008

17

Hi,
I tried your solution that can create the fields under Schema Modeler. Thanks.