
INTERNATINAL SETTINGS PROBLEM WITH SQL SERVER 6.5 ......PLEASE HELP
Dear colleagues fellow programmers,
I am making a project for a German Company using a German MS SQL Server 6.5
running on a German WinNT with German country settings. My clients, where
we program and test are all US English settings (Win 98).
The scenario is this: When we set the clients to US English which uses a
point . as decimal divider then the data are entered into the SQL server
without problems (even though the server is German???). When we set the
country settings to German (Standard) then it crashes because here the
decimal divider is , comma. Comma is also the field divider in the SQL
statement.
The funny part is that if we format the value to be entered in the server
like this:
strMarkup = Format(Me.txtField(8).Text, "###,###,##0.00") Formatting the
number to use . as decimal divider
mMarkUp = CSng(strMarkup) Convert value to a single (as on the server)
thus making mMarkUp the value to enter into the server then a , (comma) is
still used as decimal divider and not the . (dot) as would be expected.
Then is something here we dont understand..
Im sure that there is a logical explanation for that and I would highly
appreciate if somebody could send me a short mail explaining why, and maybe
how to get around it.
Please send the mail to this news group for everyone to share along with a
Hope to hear from a knowledgeable colleague soon,