What is the corresponding C++ data type to the SQL numeric(18,0) data type?

Question

I need a data type in C++ to store numeric(18,0) of SQL in it.

(18,0) means 18 digits before the decimal point and 0 after. So you can use a `long long` or `int64_t` or `__int64` or whatever is the 64 bit integer on your system. — Mr Lister, May 02 '12 at 07:01
my problem is _variant_t that reads data from sql does not support LONGLONG — Bob, May 02 '12 at 07:07
You are using MSVC, right? What version? AFAIK variant_t does support 64 bits ints. Oh, and what kind of database are you reading from? SQL Server? — Mr Lister, May 02 '12 at 07:10
Oh, I just read your other question, where you say this is for the WinCE platform, and _variant_t doesn't contain __int64 there. I didn't know, and I have no idea how to solve that, sorry. — Mr Lister, May 02 '12 at 07:28

score 4 · Accepted Answer · edited Jul 12 '21 at 23:40

4

It says on MSDN that the numeric is mapped to CString in C++.

edited Jul 12 '21 at 23:40

Peter Mortensen

answered May 02 '12 at 07:01

phantasmagoria

score 1 · Answer 2 · answered May 02 '12 at 07:00

1

That would be a long long (at least 64 bits).

answered May 02 '12 at 07:00

wallyk

2 Answers2