Thread: A Question on SQL_C_NUMERIC

A Question on SQL_C_NUMERIC

From
Vijaya Kumar Yoganna
Date:

Hi,

 I am working on ODBC application.

I knew that ODBC 3.x application support SQL_C_NUMERIC type, which means internally the data will be interpreted or stored in the SQL_NUMERIC_STRUCT structure.

 

Now lets assume , user binds a value using SQLBind Parameter, and his value is 123.45, with SQL_C_NUMERIC type.

 

How does this value is parsed and stored in the structure and also how this value is stored in the database(will it be stored as a string or as a structure).

 

 

Also what happens whenver a "Select statement is executed". Will the value from the database is read as a structure or as a string. How parsing is done at the engine level.

 

Are there are any free source code, so that one understands very easily just looking at it

 

Thanks,

 Vijay

 

 

Re: A Question on SQL_C_NUMERIC

From
"Sivakumar K"
Date:

Vijay,

            You are always welcome to browse the source code and get what you want.

The entire psqlodbc source code is available at http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/

 

In case of any doubt, please revert back to the psqlodbc community.

 

 

Regards,

Siva Kumar.K

-----Original Message-----
From: pgsql-odbc-owner@
postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Vijaya Kumar Yoganna
Sent:
Saturday, September 24, 2005 12:41 PM
To:
pgsql-odbc@postgresql.org
Subject: [ODBC] A Question on SQL_C_NUMERIC

 

Hi,

 I am working on ODBC application.

I knew that ODBC 3.x application support SQL_C_NUMERIC type, which means internally the data will be interpreted or stored in the SQL_NUMERIC_STRUCT structure.

 

Now lets assume , user binds a value using SQLBind Parameter, and his value is 123.45, with SQL_C_NUMERIC type.

 

How does this value is parsed and stored in the structure and also how this value is stored in the database(will it be stored as a string or as a structure).

 

 

Also what happens whenver a "Select statement is executed". Will the value from the database is read as a structure or as a string. How parsing is done at the engine level.

 

Are there are any free source code, so that one understands very easily just looking at it

 

Thanks,

 Vijay