Regional Settings - again

[mike browne]

Hello,

I posted this awhile ago and have hit the problem, so I hope someone can assist me. I have also found that because the data delimeter or information delimeter for mysql is a comma, that the numeric values with a decimal position represented by a comma really mess things up.

So this type of statement:

Insert Into Table1 set Field1='hello', Field2=0,123456

Will cause a syntax error. Field2 is really a decimal value but because of the regional settings the decimal is represented by a comma.

So again I ask, how are these issues handled.

I have an application that will be run in a Spanish Regional Settings environment, but my MySql will be in an English( United States ) Regional Setting. So my problem is, how do I deal with the differences in respect to say dates and decimal fields.

For example : a decimal value of 0.123456 would be sent to the database as 0,123456 to the database. So, how do I handle this type of issue on the database side.

Thank you for any information on this issue.

Mike