Re: isnumeric-error in result, attn Microsoft
From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 02/17/04
- Next message: kriste: "Re: store procedure to write multi lines to txt file"
- Previous message: Roji. P. Thomas: "Re: Passing in Parameters to Stored Procedures"
- In reply to: Fred: "isnumeric-error in result, attn Microsoft"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Feb 2004 13:06:40 +0100
Fred,
> In Query Analyzer (at the server):
> select isnumeric('.') returns 1
> select isnumeric('1') returns 1
> select isnumeric('1.1') returns 0 !!!
> I then use Enterprise Manager (at the server):
> select isnumeric('1.1') returns 1
> I go back to Query Analyzer which is still open and re execute:
> select isnumeric('1.1') now returns 1 !!!
> I close Enterprise Manager and Query Analyzer, then reopen Query Analyzer
within minutes
> select isnumeric('1.1') returns 1
> I close QA again, wait say one half hour, reopen QA and
> select isnumeric('1.1') returns 0 !!!
> and so on...
>
> Changes to the server since it last worked correctly
> Microsoft Windows auto update on 15 Feb
> ODBC configuration changes to ensure Regional settings and OEM/ANSI
conversions enabled on all dsns
> Client Network Util, DB-Library options OEM/ANSI conversion and
international settings enabled
>
> Any thoughts as to why it takes the EM query to "wake up" the QA query,
and why it all seems to reset itself?
> Thanks
> Fred
My guess it is due to local character translation in ODBC configuration. I
can't reproduce this at the moment. But a short advice: if you suspect this
is a bug, do please include version and SP level of the SQL Server. data
access components and OS, including regional settings. The more info the
better!
-- Dejan Sarka, SQL Server MVP Associate Mentor Solid Quality Learning More than just Training www.SolidQualityLearning.com
- Next message: kriste: "Re: store procedure to write multi lines to txt file"
- Previous message: Roji. P. Thomas: "Re: Passing in Parameters to Stored Procedures"
- In reply to: Fred: "isnumeric-error in result, attn Microsoft"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
