Hi,
I have a problem with an ASP page pulling data from a SQL2000 server.
Expected behaviour is that when prices are displayed they are displayed in
pounds as this is the default locale of the server. However they are
displayed in dollars.
I've checked the default locale and the user locale of the (windows 2000)
server and these are both British england. The language for the SQL user is
also British english.
Are there any other settings in SQL 2000 server that could affect this?
Thanks,
TimSQL Server displays money data types as numbers. It does not have any =currency symbols. How are you displaying the data within your active =server page? Perhaps you need to make sure that the code which displays =the data is correct. If it is, one more thing to check would be to make =sure that a smart developer has not hard coded the currency display =within the stored procedure or sql statement which returns the data.
-- Keith, SQL Server MVP
"Tim Harrison" <tim_eridge@.hotmail.com> wrote in message =news:OeHqV8uSDHA.2148@.TK2MSFTNGP11.phx.gbl...
> Hi,
> > I have a problem with an ASP page pulling data from a SQL2000 server.
> Expected behaviour is that when prices are displayed they are =displayed in
> pounds as this is the default locale of the server. However they are
> displayed in dollars.
> > I've checked the default locale and the user locale of the (windows =2000)
> server and these are both British england. The language for the SQL =user is
> also British english.
> > Are there any other settings in SQL 2000 server that could affect =this?
> > Thanks,
> > Tim
> >
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment