Storing decimals to Pervasive SQL database

[Hans van de Laar]

Within an VB.net application I'm trying to store decimal values to a
Pervasive SQL table. The decimal values comes from a xml file and is
looking something like:
<Grade1>6.65</Grade1>
<Grade2>6.66</Grade2>
<Grade3>6.0</Grade3>

When I look for the results in the database I find 665, 666 and 60 for
the corresponding columns. All types are setup as decimals. What I'm I
doing wrong?

Regards,
Hans

 

[PvdG42]

Within an VB.net application I'm trying to store decimal values to a
Pervasive SQL table. The decimal values comes from a xml file and is
looking something like:
<Grade1>6.65</Grade1>
<Grade2>6.66</Grade2>
<Grade3>6.0</Grade3>

When I look for the results in the database I find 665, 666 and 60 for
the corresponding columns. All types are setup as decimals. What I'm I
doing wrong?

Regards,
Hans

It appears that Pervasive doesn't understand .NET System.Decimal. I'd ask
Pervasive tech support:

http://ww2.pervasive.com/Pages/Products.aspx (click the Support tab).

 

[Patrice]

It could be also a conversino problme issue. For example if you convert
those value with . as the thousand separator, it's likely you'll get the
same result (i.e. the point is dropped and it left you with 665, 666 and
60).

I would check where you convert text values to decimals and would check the
cultutre that you are currently using.

 

[Hans van de Laar]

Patrice,

Thanks, it seems indeed a culture info problem. I programmatically
changed the culture to "n-US" and I noticed the values are now stored
correctly into the database.

Thanks,
Hans