Conversion : TEXT field truncation (10)

[keith99]

I am testing a MSACCESS/MySQL conversion tool.

Conversion worked well apart from the conversion of : (Access)"MEMO" field to (MySql)"TEXT" field.

The (MySql) "TEXT" field created has no length specified but only accepts 10 characters then truncates.

The tablename is "area1" the fieldname is "w4text" its type is "text"

I want to set this field to accept say "500" characters or whatever but I am trash at MySql. Here is what I tried and failed with ...


# Server: 3.23.35-log
SELECT VERSION()
SHOW VARIABLES
SHOW STATUS
SHOW PROCESSLIST
SHOW TABLES FROM web4uk
SHOW TABLE STATUS
SHOW FIELDS FROM area1
SHOW KEYS FROM area1
SHOW KEYS FROM area1
ALTER TABLE area1 CHANGE w4text w4text TEXT(500)
Error: 1064 - You have an error in your SQL syntax near '(500) ' at line 1


Any suggestions welcome. Feel free to laugh at me

Thanks

 

[wafia]

Instead of using text datatype in mysql try using longtext

 

[KarveR]

Also don't bother to specify the length.

Instead of SHOW FIELDS FROM area1
try; describe area1; ***************************************
Party on, dudes!