Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    1

    Question Unanswered: Convert a varchar field to a text field?

    Hi,
    how can i convert a varchar field to a text field?
    I try with

    alter table doc_valor modify sustituto text;

    but it doesn't work .....
    [Error] Script lines: 1-1 --------------------------
    Illegal attempt to convert Text/Byte blob type. 

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    I suggest that run unload table to file plane, and load to other new table with new format.
    Or alter table of VARCHAR to CHAR

    Gustavo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •