Hi, Use MSDN Library as well, a lot of things are documented more properly.:)
CultureInfo.InvariantCulture returns an instace of a CultureInfo class. It is a culture that is much like en-US but is guaranted to be exactly the same on all systems, runtimes and versions. By using a specific culture for formatting numbers you don't have to take care about different cultures. Note that I don't know whether there are other decimal separators, but custom cultures can be created as well, so there can be virtually any kind of decimal separator character. Kornél ----- Original Message ----- From: "xavier de Blas" <[EMAIL PROTECTED]> To: "Kornél Pál" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Saturday, February 11, 2006 11:40 AM Subject: Re: [Mono-list] Numbers with "," Hello, i thought there were only this decimal separators in different cultures: ',' '.' CultureInfo.InvariantCulture is not documented in my Monodoc (1.1.13) Can you explain a bit more why to use InvariantCulture? Thanks On ds, 2006-02-11 at 11:28 +0100, Kornél Pál wrote:
Hi, You should use myDouble.ToString(CultureInfo.InvariantCulture) instead of assuming a specific decimal separator and replacing that to decimal point. Kornél ----- Original Message ----- From: "xavier de Blas" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, February 11, 2006 11:15 AM Subject: Re: [Mono-list] Numbers with "," > Hello Paulo > > When I INSERT in SQL i always insert with '.' as decimal point > separator, i do it like this: > > Util.ConvertToPoint(myDouble) > > > On util class i have: > > > public static string ConvertToPoint (double myDouble) { > StringBuilder myStringBuilder = new > StringBuilder(myDouble.ToString()); > myStringBuilder.Replace(",", "."); > return myStringBuilder.ToString(); > } > > //sometimes i do it as a string > public static string ConvertToPoint (string myString) { > StringBuilder myStringBuilder = new StringBuilder(myString); > myStringBuilder.Replace(",", "."); > return myStringBuilder.ToString(); > } > > > When I SELECT i do: > > while(reader.Read()) { > myArray.Add (reader[0].ToString() + ":" + > Util.ChangeDecimalSeparator(reader[1].ToString()) + ":" + > (...) > } > > on Util class i have: > > //used for load from the database all numbers with correct decimal > separator (locale defined) > public static string ChangeDecimalSeparator(string myString) { > if(myString == "") { > return "0"; > } > System.Globalization.NumberFormatInfo localeInfo = new > System.Globalization.NumberFormatInfo(); > localeInfo = System.Globalization.NumberFormatInfo.CurrentInfo; > > StringBuilder myStringBuilder = new StringBuilder(myString); > if(localeInfo.NumberDecimalSeparator != ".") { > myStringBuilder.Replace(".", localeInfo.NumberDecimalSeparator); > } > return myStringBuilder.ToString(); > } > > > This are pieces of code of Chronojump, files: > http://cvs.gnome.org/viewcvs/chronojump/src/sqlite/jump.cs?rev=1.15&view=log > http://cvs.gnome.org/viewcvs/chronojump/src/util.cs?rev=1.19&view=log > > http://gnome.org/projects/chronojump > > > A bondade > > > > On ds, 2006-02-11 at 00:56 +0000, Paulo Augusto wrote: >> In portuguese (in fact, every language i know except english), numbers >> are separated by a "," comma, instead of by a "." dot. >> >> So, when my mono program needs a number from an Entry(): >> Convert.ToSingle (string); >> and then i want to pass that number to MySql through an sql string: >> float.ToString(); >> results in a string that has a "," which brakes the sql string. >> >> Anyone has any idea on what's the best way to handle this localisation >> issue? >> >> I tried working around it with: >> string.Replace (char, char); >> and >> string.Replace (string, string); >> to the resulting string but i think both are broken since they do not >> work at all. >> >> One would think this issue would be frequent but i do not seem to be >> able to find any information at all anywhere about it. >> _______________________________________________ >> Mono-list maillist - [email protected] >> http://lists.ximian.com/mailman/listinfo/mono-list > > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list > _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
_______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
