Databases
StackOverflow2013
Postsdbo
POHow to get to retrieve Bytes[] from VARCHAR in Ado.Net?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to get to retrieve Bytes[] from VARCHAR in Ado.Net?
    primarykey
    data
    text
    <p>I need to retrieve some data stored as varchar in an SQL table to bytes[] in c#.</p> <p>The SQL server is running MS SQLServer 2005. The table in question has a column defined as varchar(3900), non null. This column is usually filled by c++ code writing different POD structures straight into the column. Basically passing the pointer to the structure to the c++ sql code updating the table. Different c++ programs read and write to this table and share the same headers describing those POD structures. The type of POD structure is indicated by another column in the table. Lets call it DataType The way the table is defined (as the column) cannot be changed. It would require a way to huge change in the currently functioning systems.</p> <p>How can I get the full content (the 3900 bytes) of the varchar to Bytes[] in C# My aim is use ADO.net to get rows from this table. Read this column and the DataType one. Depending on DataType build an Object following the skeleton of the c++ POD structure.</p> <p>Then how to write back to the table from my C# Object to the varchar(3900).</p> <p>I read this <a href="https://stackoverflow.com/questions/2553285/how-to-get-varchar-as-byte-using-datareader-in-ado-net">question</a> but it seems ADO.net sees this column as string and then truncate the content. I cannot seem to get the "raw" content of the varchar column.</p> <p>Any idea?</p> <p>Edit:</p> <p>In c++ The data written to the column is declared as a <code>char[3901]</code>. Complete POD structures are "written" over it using <code>memcopy</code>. Before being stored in the table using ADO: It is first converted to a WideCharString using <code>MultiByteToWideChar</code> Then to a Bstring <code>BSTR</code> which in turn is put into a <code>VARIANT</code> and finaly used by ADO to update the table.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USuser1238350
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to get to retrieve Bytes[] from VARCHAR in Ado.Net?
      1. USChuck Savage
      1. VTFavorite
    2. VO
      singulars
      1. POHow to get to retrieve Bytes[] from VARCHAR in Ado.Net?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COplease show some code.. what have you tried ? what is not working ?
      singulars
      1. POHow to get to retrieve Bytes[] from VARCHAR in Ado.Net?
      1. USYahia
    2. COVarchar does not map to byte[] - it maps to char[] or (more commonly) string. This shouldn't be truncated; you should be ok to jut use regular mapping, or GetString if using a reader.
      singulars
      1. POHow to get to retrieve Bytes[] from VARCHAR in Ado.Net?
      1. USMarc Gravell
    3. COAs already stated, `varchar` holds `string` data. Your actual question is how to convert some `string` (or `char[]`) to a `byte[]`. There is no simple answer without an example of before and after.
      singulars
      1. POHow to get to retrieve Bytes[] from VARCHAR in Ado.Net?
      1. USJodrell
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload