Here is the binary equivalent of COPY FROM for Python 3: from io import BytesIO from struct import pack import psycopg2 # Two rows of data; “id” is not in the upstream data source # Columns: node, ts, val1, val2 data = [(23253, 342, -15.336734, 2494627.949375), (23256, 348, 43.23524, 2494827.949375)] conn = psycopg2.connect(“dbname=mydb user=postgres”) curs … Read more
Right click the resource script (.rc file) Choose Import http://msdn.microsoft.com/en-us/library/saced6x2.aspx You can embed any “custom” file you want, as well as things like .bmps and stuff VisualStudio “knows” how to edit. Then you can access them with your framework’s resource functions like FindResource LoadResource etc… If you don’t have a resource script. Click Project Add … Read more
Note: This addresses binary data, but not encrypted data. See this answer for searching on encrypted data. Try adding X, x or 0x in front of binary data used for search: SELECT id FROM test WHERE pid = ‘0xÞFÈ>ZPÎ×jRZ{æ×’; EDIT: try also this: SELECT id FROM test WHERE BINARY pid = ‘ÞFÈ>ZPÎ×jRZ{æ×’; OR SELECT id … Read more
vector of char is nice because the memory is contiguious. Therefore you can use it with a lot of C API’s such as berkley sockets or file APIs. You can do the following, for example: std::vector<char> vect; … send(sock, &vect[0], vect.size()); and it will work fine. You can essentially treat it just like any other … Read more
This really depends on the nature of the binary data, and the constraints that “text” places on your output. First off, if your binary data is not compressed, try compressing before encoding. We can then assume that the distribution of 1/0 or individual bytes is more or less random. Now: why do you need text? … Read more
To answer your question: function Hex2Bin(n){if(!checkHex(n))return 0;return parseInt(n,16).toString(2)} Here are some further functions you may find useful for working with binary data: //Useful Functions function checkBin(n){return/^[01]{1,64}$/.test(n)} function checkDec(n){return/^[0-9]{1,64}$/.test(n)} function checkHex(n){return/^[0-9A-Fa-f]{1,64}$/.test(n)} function pad(s,z){s=””+s;return s.length<z?pad(“0″+s,z):s} function unpad(s){s=””+s;return s.replace(/^0+/,”)} //Decimal operations function Dec2Bin(n){if(!checkDec(n)||n<0)return 0;return n.toString(2)} function Dec2Hex(n){if(!checkDec(n)||n<0)return 0;return n.toString(16)} //Binary Operations function Bin2Dec(n){if(!checkBin(n))return 0;return parseInt(n,2).toString(10)} function Bin2Hex(n){if(!checkBin(n))return 0;return … Read more
I’m sure you will find this helpful: http://jsdo.it/tsmallfield/uint8array. Click on javascript tab. There will appear the code to convert the Uint8Array in a string. The author shows 2 method: The first is about creating a view. The second offsetting bytes. EDIT: report the code for completeness var buffer = new ArrayBuffer( res.length ), // res … Read more
It appears that storing the data in a BINARY column is an approach bound to perform poorly. The only fast way to get decent performance is to split the content of the BINARY column in multiple BIGINT columns, each containing an 8-byte substring of the original data. In my case (32 bytes) this would mean … Read more
The following code will give you a hex dump of arbitrary memory from within your code. #include <stdio.h> // Usage: // hexDump(desc, addr, len, perLine); // desc: if non-NULL, printed as a description before hex dump. // addr: the address to start dumping from. // len: the number of bytes to dump. // perLine: number … Read more
0x1A is Ctrl-Z, and DOS historically used that as an end-of-file marker. For example, try using a command prompt, and “type”ing your file. It will only display the content up the Ctrl-Z. Python uses the Windows CRT function _wfopen, which implements the “Ctrl-Z is EOF” semantics.