Execute this in Query Analyzer:

SELECT CONVERT(varchar(8),0x0131) as A, 'X' as B

You will get the expected results if you choose "Results in text", but
if you choose "Results in grid" you will get nothing in column A and
'1' in column B.

Is there anyone at MS reading this ?
Is there any other place I should report this bug ?

Razvan Socol

I can report this as a bug. It does appear taht the grid does not return
the correct information, or atleast does not interpret it correctly.

Rand
This posting is provided "as is" with no warranties and confers no rights.

This inserts two characters into A: 0x01 and 0x31. 0x31 is, of course, an
ASCII '1'.

Now you know that 0x01 is the character that QA uses to separate columns
into the grid.

So, the grid has two columns defined by the select, but when populating the
columns QA sees three columns of data: NULL, '1', and 'X'. This causes the
final column of data not to have a home.

So, is this a bug? If Microsoft is willing to think so, that is great, but
I would consider this a behavior instead of a bug.

Russell Fields


"Razvan Socol" <rsocol (AT) fx (DOT) ro> wrote

I definitely think that it's a bug. I specifically simplified the
query to this form (the situation I encountered was more complex). I
understood all that you explained before I posted, but it's good that
you did explain it, so that other readers understand.

Razvan

"Russell Fields" <RussellFields (AT) NoMailPlease (DOT) Com> wrote: