|
Replies:
4
-
Pages:
1
-
Last Post:
Nov 22, 2010 2:18 AM
by: x21_921
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
3
Registered:
11/1/10
|
|
|
|
Excluding results
Posted:
Nov 1, 2010 4:55 PM
|
|
|
I installed version 5 and when I do the following query
select date_format (current_date, '% Y-% m-% d') as data
the result is (Excluded)
Can someone help me?
|
|
|
Posts:
20
Registered:
2/16/10
|
|
|
|
Re: Excluding results
Posted:
Nov 1, 2010 5:44 PM
in response to: lluis
|
|
|
The only time I have seen "Excluded" was when the result was a LOB.
You need to either click on the grid to view the record contents or select Tools/Options/Database/General and click on "Read LOBs when initially fetching data".
Linda
|
|
|
Posts:
3
Registered:
11/1/10
|
|
|
|
Re: Excluding results
Posted:
Nov 1, 2010 7:22 PM
in response to: Linda
|
|
|
Linda Thanks for your response.
I tried your answer but the information I get is 0x323031302D31312D3032 ...
If you click on the result I can see it in Hex, ASCII and UTF-8.
You know how to get the result directly in ASCII and UTF-8?
|
|
|
Posts:
20
Registered:
2/16/10
|
|
|
|
Re: Excluding results
Posted:
Nov 1, 2010 10:23 PM
in response to: lluis
|
|
|
I'm not sure how to fix this.
I noticed it myself for the first time yesterday but it only occurs in version 5 of Toad for MySQL for me. I just went back to version 4 and the output was fine.
In my case I had to use cast/convert to allow the character and integer values to appear in the output without being converted to hex.
Linda
|
|
|
Posts:
5
Registered:
6/1/10
|
|
|
|
Re: Excluding results
Posted:
Nov 22, 2010 2:18 AM
in response to: lluis
|
|
|
Don't quote me on this, but at some point when I had upgraded mysql my dates started coming across as byte[]'s in java that I would have to convert back to ascii, maybe you are having the same issue here?
Try giving the result a CAST to char like this following example... (it worked on my system)
SELECT CAST(date_format(current_date, '%Y-%m-%d') AS char) AS data
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
