Double or float problem

Hello,
I live in the netherlands and we use a comma as separator for money.
Like 10,50 and bigger values like 1.333,50.
But mysql wouldnt accept that value and wants a dot as separator.
Can i change the settings in mysql so he accepts it like this way?

I am coding in vb.net (for now) and he output 10,3 and using a double variable.

Thanks!
Paul

re: Double or float problem

Hello Paul,

You should save the value in standard format in MySQL and use VB.Net to display the values in your desired format.

re: Double or float problem

Okay, i will try it tomorrow.
It's almost 01:00 now. :(

Thanks!