Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    19

    Unanswered: Text To Varchar Conversion

    HOW CAN I SONVERT A TEXT FILED TO VARCHAR. I TRIED USING CONVERT FUNCTION BUT IT TRUNCATES THE DATA IN THE TEXT FILED

    PLSSSS HELP

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    Varchars have a max of 255. If your text is larger than that, it will be truncated. Why do you need to change data types?

  3. #3
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Actually varchars can be quite a bit larger than 255 in ASE 12.5 and later. The exact size depends on the page size, and whether the target is a variable or a table column, up to a maximum of 16k.

    Michael

Posting Permissions

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