Results 1 to 1 of 1
Thread: Sql Server Internationalization
Jul 11, 2003, 02:46 #1
Sql Server Internationalization
I have an ASP App., which sets the Session LCID according to the user's accepted language string. So I don't really know what format dates and currencies are being displayed in.
Everything works fine ASP / Browser side, but as soon as I try to store a currency value into an MS SQL Field of type MONEY the server chokes because the value has a decimal comma instead of a decimal point.
My SQL Server 2000 is running in English, and my ASP Session theoretically in German. The German enters :
into a form to mean 20 Euros. The SQL Server expects to see the data in this format:
using a point instead of a comma. Now how do I get the currency translation going properly with least overhead, assuming I have no idea what formatting is being applied?