regional settings

[tyris]

hi all,

i have a question about input regional settings.

i know there is an attribute in SQL (SQL_SOPT_SS_REGIONALIZE
, you can have a look at :

http://msdn.microsoft.com/library/psdk/sql/od_odbc_s_8pv6.htm)

that deals with output regional settings (when the numeric settings of the database are different then the user's one, for exemple if in US you have 1,250.25 it will be 1.250,25 in french or german).

is there something for the input ? i mean the user enter a numeric value and the database enters it by convering the value, based on the user's regional settings ...)

i know that we can interprate a numeric value and change it with a code (in VB for exemple), but it's not a clean method, and some exceptions will always be forgotten.

any idea ?
Best regards,
Elise