Announcement

Collapse
No announcement yet.

[SOLVED] database builder

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] database builder

    when i change to varchar field in a table produces error:

    Syntax error near 'COLLATE 'utf8_general_ci' NOT NULL AFTER `Youtube`, COMMENT='' REMOVE PARTITIONI' at line 2 Comando SQL
    ALTER TABLE `book`
    CHANGE `Allegato` `Allegato` varchar COLLATE 'utf8_general_ci' NOT NULL AFTER `Youtube`,
    COMMENT=''
    REMOVE PARTITIONING;

  • #2
    Not sure which database you use, but the third party Database builder does have some issues. Just copy/paste the statment into the sql window of the database builder and modify it to the correct syntax. What where you trying to do?
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      i solve,thanks.....use mysql, you must enter the length of the field

      Comment

      Working...
      X