Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric)

From: Calin (pocal7_at_yahoo.com)
Date: 12/23/03


Date: 23 Dec 2003 00:34:31 -0800

Hello,

I made one application that opens MS Access databases.And I have one
problem.How can I find the real data type of columns(text, memo,
OLEObject, numeric) like it is into Access.I tried with
resultSetMetaData.getColumnType(columnIndex) but I receive
java.sql.Types.I have two columns that contains OLEObjects(images).But
I receive two different types for columns : VARCHAR once, and for
second column SMALLINT.I only want to see the types like in
Access(OLEObjects, Text, Numeric, Memo...).Thanks in advance!

Best regards,
Calin Pop



Relevant Pages

  • column type
    ... I made one application that opens MS Access databases.And I have one ... problem.How can I find the real data type of columns(text, memo, ... OLEObject, numeric) like it is into Access.I tried with ...
    (comp.lang.java.databases)
  • Re: Creating a reply to an email message using html
    ... In the reply memo the subject is present with RE: ... I don't think that with HTML alone you can then paste in anything for the body of the email. ... The other option is to do this on your own email server - so the link doesn't open a new email it opens a new page on your server and you simulate the look and feel of an email client. ...
    (alt.html)
  • Re: Binary / OLE Feld in Access DBK definieren
    ... Wobei das mit Memo = longtext und OleObject = longbinary recht kompliziert ... Peter ...
    (microsoft.public.de.vb.datenbank)
  • Re: After a power failure I lost all my info in outlook
    ... There is zero message when I go file>open>Outlook data>Outlook.pst ... The earlier memo - "There are no items to show in this view." ... disappears and the file name appears in the bar above, ... >> program it opens an email in word with the file as an attachment! ...
    (microsoft.public.outlook)
  • Re: Need grid to display MEMO, or do I?
    ... functionality that might work for you: ... a small dialog box opens up where ... you can edit the text. ... It also shows the actual text instead of <MEMO> ...
    (borland.public.delphi.thirdpartytools.general)