Blob Or Binary??
Jul 24, 2006
I am looking for some help, I have a access database that is interfacing to a sql storage.
The problem I am having, is I have a Image that is containing archives for emails, however I have been yet to figure out hor to read that text stored in the image.
So far I have been able to come up with the data being stored in binary, but am unable to read it in a access form.
Make sence? Hope so.
Through SQL, I am able to run a query to read the data:
SELECT CONVERT(varchar(8000),CAST (body AS binary(8000) )) from arc_bodies
However I would like this text to be read through a form in access, and am unable to figure out how... Please help if possible, would be greatly appreciated.
View Replies
ADVERTISEMENT
Dec 23, 2006
We have saved image in the database as OLE Object. It is showing “Microsoft Photo Editor 3.0 Photo / Package” in the table. We want to convert it into Binary Data to other table using VBA Code / Visual Basic Code . Please help us to solve this problem.
Thanks in advance
View 3 Replies
View Related
Oct 5, 2007
Hello,
I have a OLE Object field in my Access table. It has a blob (long binary data) already in it. It is a very small .bmp image. How do I get this image from the table loaded in a form to it displays the image? I tried setting this value to a image box, bound object field on form load but nothing is working. Any help would be great. Thanks
Joe
View 2 Replies
View Related
Jan 6, 2006
I am trying to store binary values (as decimal long integers) and then use bitwise comparisons to update the values. MS help suggest that the standard logical operators (And or etc) can do bitwise comparison as opposed to comparing boolean logical values for expressions; but I have found no way of making this work.
Is this possible? Any ideas. Doing it mechanically, by splitting the decimal into the relevant parts for any bit is very tedious!
Gibbo
View 3 Replies
View Related
Dec 6, 2006
Hi
I have a problem in binary type in access
I have some values that are between 1 to 32 byte
I want to specify the type of my field to something like "varbinary" such as SQL server but I have not this type
actually I used OLE object type but it doesn't like it.
for example when I use:
insert into t_t1(i,j) values(1,23)
while j's type is OLE object,
the row is inserted but I can not see the value of j column and I can not select on j column too for example
select * from t_t1 where j=23
has no result.
furthermore, I want to use hex values but I can not do it.
when I use
insert into t_t1(i,j) values(1,0xAD)
I got an error that says the type is mismatched
I know it may shows I expect unreasonably from access but please help me to find the solution
thanks for your attention
Best regard
View 1 Replies
View Related
Jan 29, 2007
Hi there,
I have a simple bit of VBcode in my database which reads the password a user enters and 'encrypts' it for storing in the user table. It's more obfuscation than encryption to be honest, and I feel limited by the 'text' data type assigned to the password field.
At the moment it works by taking the password entered, and converting the whole lot into a byte array, then for each 'character' in the array, changing its binary value. At the moment it's then converted back into a string and dumped into the 'password' field, as garbage characters. But they are still characters, and if I go out of range of the character set it results in horrible errors :D.
I feel I may be missing the blindingly obvious and could just not convert it back to string, and write the binary into a text field instead, but I'm not sure how I'd get intelligible data back.
The reason it's not exactly encryption is because the key is the same for all characters on all passwords (I just multiply the binary value by 2!) what I want is to have a key as well, stored in another field alongside, but again can't implement this due to character-set range issues.
So my question is - is there a 'raw' data field hidden somewhere amongst the features of microsoft access, or should I be thinking about just storing the numbers themselves? For the moment I'll investigate the latter, but I'll appreciate any help! Thanks :)
View 1 Replies
View Related
Sep 24, 2013
I have a text column with hexadecimal strings like "4E1B0A65FE3299FE", ie. of length 16.I'm doing an ALTER COLUMN query to convert the column to varbinary, but Access is doing conversion by ASCII, which results in a varbinary field of size 32, I think this is because the text column is in Unicode.
SQL Server has something called "styles" which are used with CONVERT.where you can choose to convert by two characters at a time 2:1..How do I do the same in an Access query? CONVERT/CAST are no supported.
View 1 Replies
View Related
May 10, 2014
i want to copy binary data to another table with same structure.
how can i do this.
View 4 Replies
View Related
May 30, 2013
I have requirement to draw a binary tree in forms, how to implement this?
View 1 Replies
View Related
Jan 31, 2008
This the first time I post in this forum and I tried looking for an answer to my question before posting, so I apologize if my question has been answered previously.
Is it possible to determine, in Access 2000, the data type in a Make-Table query of a new column with null value so that it does not default to binary.
Here is my sample sql:
SELECT tblAddressBook.Name, Null AS Email INTO tblTestTable
FROM tblAddressBook;
The output is tblTestTable with two columns: Name and Email. The data type of column Email defaults to Binary. How do I make it default to Text.
Thank you.
View 4 Replies
View Related
Oct 7, 2014
I am looking for a function that will allow me to encrypt/decrypt single image files as and when required. I have built my own simple one to encrypt a string that will be stored in a filename as all the ones I found created unusable filenames.
However I don't know where to start with the image file encryption.
(Any better way to encrypt a string that can be used in a file name that would be great too. My method is a bit basic).
View 2 Replies
View Related
Apr 8, 2013
I am working on a project that requires data transfer using TCPIP sockets. I am using a 3rd party Library (Ostrosoft) that handles the wsock32.dll api calls.
The project calls for the creation of a header that logs into a user account.
The first part of the header is a marker, with a value of 4,275,878,552. It is to be supplied in a Binary format of length 4.
My quesion is "How do I create this marker".
What I have tried so far is a string variable - strMarker thus:
strMarker = ChrB(&HFE) & ChrB(&HDC) & ChrB(&HBA) & ChrB(&H98)
Using the ChrB function to convert the Hex version of that number (FEDCBA98)
View 5 Replies
View Related
