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?
Any ideas?