Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    7

    Unanswered: Text, ntext, image data type cannot be selected as distinct

    I get the error:

    Text, ntext, image data type cannot be selected as distinct

    Whenever I run a stored procedure. I don't understand why I get this error. Should I change my data types? Does anyone know what this error is, and how I might fix it?

    Thanks,

  2. #2
    Join Date
    Jul 2002
    Posts
    55
    Stored procedure in MySQL? Are you sure? As of the 4.x alpha release I didn't think MySQL supported SPs. In fact, I'm 99.99% sure it doesn't.

    I'm guessing here but the data types you're using there are all *LOBs (large objects). I think MySQL stores *LOBs in the same way as other RDBMSs, in that the data isn't stored in a row (as it has the potential to be VERY big) but the row stores a reference to the object.

    So I'm guessing that's why you can't select distinct. Try changing the data types and see what happens.

    Hope this helps.

    Mull.

  3. #3
    Join Date
    Jul 2002
    Posts
    7
    Sorry,
    I am using SQL Server. I fixed the problem. I had to change the data type and the size. Thanks,

Posting Permissions

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