How to save decimals in SQL Server Compact Edition?

Question

decimal is a .NET (also other frameworks, rdbms and languages) value type that stores floating point numbers with decimal precision, instead of a binary one.

Is there any way of saving these values to a SQL CE database without using binary precision in the process?

Which edition of CE are you using? – Lazarus Feb 28 '12 at 13:49 — Lazarus, Feb 28 '12 at 13:49

score 5 · Accepted Answer · answered Feb 28 '12 at 13:49

5

Like the full version SQL Server, SQL Server CE supports the numeric data type:

SQL Server Compact Data Types

In contrast to the Decimal data type in .NET, you will have to fix the precision and scale when creating a numeric field.

answered Feb 28 '12 at 13:49

Heinzi

167,459
57
363
519

score 0 · Answer 2 · answered Feb 28 '12 at 13:49

0

Use numeric data type of Sql server

answered Feb 28 '12 at 13:49

Maheep

5,539
3
28
47

How to save decimals in SQL Server Compact Edition?

2 Answers2