Professional Web Applications Themes

BUG: certain characters up QA display - Microsoft SQL / MS SQL Server

I'm connecting to a SQL7 SP4 server, and my local machine has SQL2000's Query yzer. I just noticed this bug related to returning an encrypted string value. The data in the table is fine, but when I do a SELECT * FROM TABLE and this field value comes back oaPQ`'?>?+"HrA0s query yzer cuts the display at oaPQ`'? and then puts >?+"HrA0s in the next column of its display. And, it then moves all the columns (just of that row) over into the "next"/wrong (one to the right) column, and never displays the last column value. I think the  character ...

  1. #1

    Default BUG: certain characters up QA display

    I'm connecting to a SQL7 SP4 server, and my local machine has SQL2000's
    Query yzer. I just noticed this bug related to returning an encrypted
    string value.

    The data in the table is fine, but when I do a SELECT * FROM TABLE and this
    field value comes back

    oaPQ`'?>?+"HrA0s

    query yzer cuts the display at

    oaPQ`'?

    and then puts
    >?+"HrA0s
    in the next column of its display. And, it then moves all the columns
    (just of that row) over into the "next"/wrong (one to the right) column, and
    never displays the last column value.

    I think the  character (ascii 1) is causing the problem (seeing as though
    it doesn't show in either column's display), but that character shows up in
    some other columns just fine.

    Weird. Anyone else able to reproduce this?




    FN Guest

  2. #2

    Default Re: BUG: certain characters up QA display

    FN (newsgroupaccountDELETECAPS) writes:
    > I think the  character (ascii 1) is causing the problem (seeing as
    > though it doesn't show in either column's display), but that character
    > shows up in some other columns just fine.
    >
    > Weird. Anyone else able to reproduce this?
    Yes. This is a known issue, and Microsoft has acknowledged this as a bug,
    as I recall.


    --
    Erland Sommarskog, SQL Server MVP, [email]sommaralgonet.se[/email]

    Books Online for SQL Server SP3 at
    [url]http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/url]
    Erland Sommarskog Guest

  3. #3

    Default Re: BUG: certain characters up QA display

    any fix you're aware of?

    Thanks.


    "Erland Sommarskog" <se> wrote in message
    news:0.0.1... 
    >
    > Yes. This is a known issue, and Microsoft has acknowledged this as a bug,
    > as I recall.
    >
    >
    > --
    > Erland Sommarskog, SQL Server MVP, se
    >
    > Books Online for SQL Server SP3 at
    > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/ref]


    FN Guest

  4. #4

    Default Re: BUG: certain characters up QA display

    FN (com) writes: 
    >>
    >> Yes. This is a known issue, and Microsoft has acknowledged this as a bug,
    >> as I recall.[/ref]
    >
    > any fix you're aware of?[/ref]

    No.

    If you feel that this problem is important enough to warrant a fix, then
    you need to open a case with Microsoft, and the convince them that there
    business reasons good enough that requires a fix.


    --
    Erland Sommarskog, SQL Server MVP, se

    Books Online for SQL Server SP3 at
    http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
    Erland Guest

  5. #5

    Default Re: BUG: certain characters up QA display

    I've given up reporting even obvious bugs like this to Microsoft. They
    don't listen and never fix the obvious bugs. They only cater to Fortune 500
    companies and care less about small biz. And to report it by phone, they
    make you pay $250 to open up a case, convince them its a bug, and then get
    refunded the $250. I even had them take a bug report before, reproduce it
    themselves, agree it is a problem that needs immediate resolution, I
    followed up multiple times to see if anyone was doing anything about it, and
    STILL 2 years later the bug remains.

    So if someone from MIcrosoft reads this post, please report it internally
    yourself because I won't bother reporting bugs anymore.


    "Erland Sommarskog" <se> wrote in message
    news:0.0.1... [/ref][/ref]
    character [/ref][/ref]
    bug, 
    > >
    > > any fix you're aware of?[/ref]
    >
    > No.
    >
    > If you feel that this problem is important enough to warrant a fix, then
    > you need to open a case with Microsoft, and the convince them that there
    > business reasons good enough that requires a fix.
    >
    >
    > --
    > Erland Sommarskog, SQL Server MVP, se
    >
    > Books Online for SQL Server SP3 at
    > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/ref]


    FN Guest

  6. #6

    Default Re: BUG: certain characters up QA display

    Sometimes you have to help them to help yourself. If your the only one
    complaining of an issue it will most likely take a lower priority over ones
    that affect many people. This may be affecting lots of others but if no-one
    bothers to get it logged thru PSS they may never know.

    --

    Andrew J. Kelly
    SQL Server MVP


    "FN" <com> wrote in message
    news:npCQa.5526$socal.rr.com... 
    500 
    and [/ref]
    > character [/ref]
    > bug, 
    > >
    > > No.
    > >
    > > If you feel that this problem is important enough to warrant a fix, then
    > > you need to open a case with Microsoft, and the convince them that there
    > > business reasons good enough that requires a fix.
    > >
    > >
    > > --
    > > Erland Sommarskog, SQL Server MVP, se
    > >
    > > Books Online for SQL Server SP3 at
    > > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/ref]
    >
    >[/ref]


    Andrew Guest

  7. #7

    Default Re: BUG: certain characters up QA display

    You're right, but if they haven't listened when I've barked quite lately up
    that tree before (many times), I see no reason to try again. That's their
    fault, being unresponsive to bugs.

    A bug should be fixed upon even 1 report and their ability to reproduce.
    This has never happened with me. If they want to prioritize some over
    others, no problem. But if they never fix a known bug, that just reflects
    poorly upon them, and I've learned from past attempts to know it's just a
    waste of my time. When I work for IBM, then I'll try again because I think
    they only listen to the biggest of their customers.


    "Andrew J. Kelly" <com> wrote in message
    news:%23%phx.gbl... 
    ones 
    no-one 
    > 500 [/ref]
    they [/ref]
    get [/ref]
    it 
    > and [/ref]
    internally [/ref][/ref]
    as 
    > > character [/ref][/ref]
    a [/ref][/ref]
    then [/ref][/ref]
    there 
    > >
    > >[/ref]
    >
    >[/ref]


    FN Guest

  8. #8

    Default Re: BUG: certain characters up QA display

    FN (com) writes: 

    That's easy to say.

    Real world is however far more complex. A very compelling reason to
    not fix a bug, is that the impact of the fix may be that you introduce
    new bugs. Not all bugs are like that, but there are bugs of this kind.

    And even if Microsoft is a huge company, even Microsoft has limited
    resources. If the developers must make the choice of fixing a bug
    in SQL 2000 and delay the release of the next version of SQL Server,
    this is matter of priorities. It might be that the problem is not
    in issue in next version of SQL Server, because that part of the
    code has been completely rewritten, or replaced by something else.

    As I mentioned, this is a known issue, but I don't have any bug number,
    nor do I know of any KB article.

    I can only repeat that the only way you can get a fix, is to open a case.
    You may have bad experience, and indeed, it is not that simple that you
    call, and you have a fix in the mail the next day. MS cares a lot about
    business reasons, so it helps if you can convince PSS that you are
    losing revenue because of this problem.

    --
    Erland Sommarskog, SQL Server MVP, se

    Books Online for SQL Server SP3 at
    http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
    Erland Guest

Similar Threads

  1. Can't get headers to display czech characters
    By dalanca in forum Brainstorming Area
    Replies: 0
    Last Post: September 15th, 03:32 PM
  2. How to display Chinese characters under a datagrid?
    By InvestorTrade in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: June 2nd, 04:44 PM
  3. how to display unicode characters in datagrid
    By globalview in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: July 12th, 05:35 PM
  4. Want to display &#__; characters
    By mikel in forum PHP Development
    Replies: 3
    Last Post: December 5th, 06:00 AM
  5. Replies: 1
    Last Post: July 17th, 08:22 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139