How to get MySQL Native Data Type values?

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS How to get MySQL Native Data Type values?
# 1  
Old 06-17-2009
How to get MySQL Native Data Type values?

How do I get the native data type like we get in ORACLE using

OCIAttrGet(colHandle, OCI_DTYPE_PARAM, (dvoid *) &dataType, 0,
OCI_ATTR_DATA_TYPE, m_errorHandle);

It will return &datatype value for:
VARCHAR2 - 1
NUMBER - 2
Date - 12

How do we achieve this in MYSQL 5.1?
I saw in manual but not found any pointer. There is no any point described for native data types value.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

Incompatible data type fpos_t in C

This is from a program I wrote over in 1998 that I am trying to compile on a linux machine: void write_line (FILE *fp, int rec_no, line_rec *arec) { fpos_t woffset; woffset = (rec_no - 1) * sizeof(line_rec); fsetpos(fp,&woffset); fwrite(arec,sizeof(line_rec),1,fp); }On the line... (2 Replies)
Discussion started by: wbport
2 Replies

2. Programming

help with data type sizes

i'm using a C program and running it on a linux server, i got 2 adressess of 2 variables, and 2 addresses of 2 chars, and compared it. and got the size of a int and the size of a char. why is a size of a int (4 bytes) bigger then the size of a char (1 byte)? also if i do &a-&b i get 1, but if i... (30 Replies)
Discussion started by: omega666
30 Replies

3. Web Development

Data type to use for prices with commas

Hi everybody, I`m very new with PHP and Databases and I having the follow issue with prices data.. The original information is in CSV files. The prices have formatted with commas and dots as follow: 12,300.99 -->(thousands separated by commas) 3,500.25 -->(thousands separated... (10 Replies)
Discussion started by: cgkmal
10 Replies

4. Shell Programming and Scripting

Perl data type checking

I am using perl 5.8.0. I need to check some values to see it they are floats. Our system does not have Data::Types so I can't use is_float. Is there something else that I can use? The only thing in Data is Dump.pm. I am not allowed to download anything to our system so I have to use what I have.... (3 Replies)
Discussion started by: ajgwin
3 Replies

5. AIX

Value too large to be stored in data type???

Hello, I get this message : "Value too large to be stored in data type" when I try to open a 3Gb file. Can someone helps me to resolve the problem. Thank you very much (5 Replies)
Discussion started by: limame
5 Replies

6. Shell Programming and Scripting

Loading values into a MYSQL database

Where to start? Ok, I need to pick up a Worldpay exchange rates file from a url such as: https://select.worldpay.com/wcc/info?op=rates&instId=12345&op=rates-today the http response returns a exchange rates file with content-type "text/plain" content as below: #Exchange rates for... (2 Replies)
Discussion started by: kshelluser
2 Replies

7. Programming

data type limitation

I am writing some code to do analysis on the file system (HP-UX 11.11). I am using stat(..) to get file information. My problem is that the file-size may exceed the data types defined in 'sys/stat.h' & 'sys/types.h' respectively. Thus file-sizes in the Giga-byte range are not read correctly.... (2 Replies)
Discussion started by: ALTRUNVRSOFLN
2 Replies

8. Programming

time_t data type-- what does start +1 mean?

Hi, I am trying to understand an very old C program. .... time_t start, end; ptr = localtime(&start); ... fprintf(out, "%-35s 01 %5s %2s %10d 1 5 /tty/M%d/%02d %24s", buffer3, job, ver, start, mach_num,atoi(buffer), asctime(ptr)); fprintf(out, "%-35s 03 %5s %2s %10d 1 5... (9 Replies)
Discussion started by: whatisthis
9 Replies

9. Programming

FILE data type

Hi all, Can anyone tell me a little about the datatype FILE, which represents stream. What does its structure look like, and in which header file is it defined and so on... Ex : FILE *fp ; fp = fopen("filename", "w") ; (6 Replies)
Discussion started by: milhan
6 Replies
Login or Register to Ask a Question
SoXtClipboard(3IV)()													      SoXtClipboard(3IV)()

NAME
SoXtClipboard -- Provides Inventor copy/paste support INHERITS FROM
SoXtClipboard SYNOPSIS
#include <Inventor/Xt/SoXtClipboard.h> typedef void SoXtClipboardPasteCB(void *userData, SoPathList *pathList) typedef void SoXtClipboardImportCB(void *userData, Atom dataType, void *data, uint32_t numBytes) #define _XA_CLIPBOARD_ ((Atom) 0) Methods from class SoXtClipboard: SoXtClipboard(Widget w, Atom selectionAtom = _XA_CLIPBOARD_) ~SoXtClipboard() void copy(SoNode *node, Time eventTime) void copy(SoPath *path, Time eventTime) void copy(SoPathList *pathList, Time eventTime) void copy(Atom dataType, void *data, uint32_t numBytes, Time eventTime) void paste(Time eventTime, SoXtClipboardPasteCB *pasteDoneFunc, void *userData = NULL) void addPasteInterest(Atom dataType, SoXtClipboardImportCB *pasteImportFunc, void *userData = NULL) DESCRIPTION
This class manages data transfers for copy and paste. Transfers may occur within the same process, or between different processes. This uses the Xt selection mechanism to implement the ICCCM protocol for the transfer of data. METHODS
SoXtClipboard(Widget w, Atom selectionAtom = _XA_CLIPBOARD_) ~SoXtClipboard() Constructor and destructor. w is the Xt widget for which this clipboard acts as an agent. selectionAtom is the X selection through which data should be transferred. For quick data transfers, this should be XA_PRIMARY. The default is _XA_CLIPBOARD_ which uses the X clip- board selection. void copy(SoNode *node, Time eventTime) void copy(SoPath *path, Time eventTime) void copy(SoPathList *pathList, Time eventTime) This copies the passed scene graph object, and tells the X server that the clipboard now owns the selection which was specified by selectionAtom in the constructor. When a paste happens (in this window, another window, or another process), the X server will ask this clipboard for the data it copied here. The eventTime should be the time found in the X event structure which triggered the copy opera- tion, and is used to ensure synchronization of copy and paste requests. Data targets supported for export are INVENTOR_2_1, INVEN- TOR_2_1_FILE, INVENTOR_2_0, INVENTOR_2_0_FILE, VRML_1_0, VRML_1_0_FILE. Also exported for backwards compatibility are INVENTOR and INVENTOR_FILE, which are equivalent to INVENTOR_2_0 and INVENTOR_2_0_FILE. void copy(Atom dataType, void *data, uint32_t numBytes, Time eventTime) This behaves like the above copy routines, but the data can be in any format as specified by dataType. void paste(Time eventTime, SoXtClipboardPasteCB *pasteDoneFunc, void *userData = NULL) This makes a request to the X server for data to paste from the selection atom specified in the constructor (selectionAtom), then returns. When the data is retrieved from the selection owner, the pasteDoneFunc callback is invoked. The newly pasted data is passed as the callback function's pathList argument (an SoPathList). Data targets supported for import are INVENTOR_2_1, INVENTOR_2_1_FILE, INVEN- TOR_2_0, INVENTOR_2_0_FILE, VRML_1_0, VRML_1_0_FILE. Also imported for backwards compatibility are INVENTOR and INVENTOR_FILE, which are equivalent to INVENTOR_2_0 and INVENTOR_2_0_FILE. void addPasteInterest(Atom dataType, SoXtClipboardImportCB *pasteImportFunc, void *userData = NULL) This extends the paste interest to recognize an additional target as specified by dataType. It can be called multiple times to register interest in more than one extension. The pasteImportFunc will be called when data of the registered type is pasted. Passing NULL as the pasteImportFunc will remove paste interest for that data type (even if the data type is one of the defaults). This should be called before paste() so that paste() will accept pastes of data types that have been registered here. A dataType atom can be created with XmInternAtom, e.g.: XmInternAtom(XtDisplay(widget),"INVENTOR",False); SEE ALSO
SoSelection, SoByteStream, SoXt, X Selections SoXtClipboard(3IV)()