|
|
You're in the
sql server data warehouse
group:Insert Binary Data with APOSTROPHE
sql server data warehouse:
parameter you application program: CREATE PROCEDURE InsertBinaryTest @BinaryData binary(10) AS INSERT INTO binarytest VALUES(@BinaryData) GO EXEC InsertBinaryTest @BinaryData = 0x6165736467413F760000 -- Hope this helps. Dan Guzman SQL Server MVP [quoted text, click to view] "Uma" <uma@cspl.com> wrote in message news:OxDwgrSBFHA.136@TK2MSFTNGP14.phx.gbl... > The following queries are working fine: > > create table binarytest(binfield binary(100)) > > 1.insert into binarytest values(cast('123' as binary(10))) > 2.insert into binarytest values(cast(123 as binary(10))) > 3.insert into binarytest values(cast('aesdgA?v' as binary(10))) > > What should be done if I want to execute the following query? > > insert into binarytest values(cast(aesdg'A?v as binary(10))) > > Binary data : aesdg'A?v > > For apostrophe, the hexadecimal value is 27, decimal value is 39 > > This statement is required since we are actually inserting into this table > through an stored procedure which we are calling in C program. In C > program > we are sending binary data, which may also contain apostrohpe('), > comma(,), > space( ) and many more characters. > > Regards, > Shahul > > > > "Francesco Anti" <fanti @ sicosbt.it> wrote in message > news:OUWZyMSBFHA.2192@TK2MSFTNGP14.phx.gbl... >> binary data type accepts only hexadecimal values....how can you obtain an >> apostrophe from an hexadecimal representation of a bit string?? >> Can you post some example of your insert statement? >> >> Francesco Anti >> >> "Uma" <uma@cspl.com> wrote in message >> news:us32pTRBFHA.2180@TK2MSFTNGP10.phx.gbl... >> > Hi pals, >> > >> > I am trying to insert binary data in to a field(data type:binary) of a >> > table. Facing a problem with inserting if the binary data contains >> > APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the > data. >> > How could I insert that type of data into a binary field ? Could you >> please >> > guide me? >> > >> > regards, >> > Shahul. >> > >> > >> >> > >
binary data type accepts only hexadecimal values....how can you obtain an
apostrophe from an hexadecimal representation of a bit string?? Can you post some example of your insert statement? Francesco Anti [quoted text, click to view] "Uma" <uma@cspl.com> wrote in message news:us32pTRBFHA.2180@TK2MSFTNGP10.phx.gbl... > Hi pals, > > I am trying to insert binary data in to a field(data type:binary) of a > table. Facing a problem with inserting if the binary data contains > APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the data. > How could I insert that type of data into a binary field ? Could you please > guide me? > > regards, > Shahul. > >
Since you express the data as a string before the cast, do the same as usual, double each
single-quote: insert into binarytest values(cast('aesdg''A?v' as binary(10))) -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ http://www.sqlug.se/ [quoted text, click to view] "Uma" <uma@cspl.com> wrote in message news:OxDwgrSBFHA.136@TK2MSFTNGP14.phx.gbl... > The following queries are working fine: > > create table binarytest(binfield binary(100)) > > 1.insert into binarytest values(cast('123' as binary(10))) > 2.insert into binarytest values(cast(123 as binary(10))) > 3.insert into binarytest values(cast('aesdgA?v' as binary(10))) > > What should be done if I want to execute the following query? > > insert into binarytest values(cast(aesdg'A?v as binary(10))) > > Binary data : aesdg'A?v > > For apostrophe, the hexadecimal value is 27, decimal value is 39 > > This statement is required since we are actually inserting into this table > through an stored procedure which we are calling in C program. In C program > we are sending binary data, which may also contain apostrohpe('), comma(,), > space( ) and many more characters. > > Regards, > Shahul > > > > "Francesco Anti" <fanti @ sicosbt.it> wrote in message > news:OUWZyMSBFHA.2192@TK2MSFTNGP14.phx.gbl... >> binary data type accepts only hexadecimal values....how can you obtain an >> apostrophe from an hexadecimal representation of a bit string?? >> Can you post some example of your insert statement? >> >> Francesco Anti >> >> "Uma" <uma@cspl.com> wrote in message >> news:us32pTRBFHA.2180@TK2MSFTNGP10.phx.gbl... >> > Hi pals, >> > >> > I am trying to insert binary data in to a field(data type:binary) of a >> > table. Facing a problem with inserting if the binary data contains >> > APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the > data. >> > How could I insert that type of data into a binary field ? Could you >> please >> > guide me? >> > >> > regards, >> > Shahul. >> > >> > >> >> > >
Hi pals,
I am trying to insert binary data in to a field(data type:binary) of a table. Facing a problem with inserting if the binary data contains APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the data. How could I insert that type of data into a binary field ? Could you please guide me? regards, Shahul.
The following queries are working fine:
create table binarytest(binfield binary(100)) 1.insert into binarytest values(cast('123' as binary(10))) 2.insert into binarytest values(cast(123 as binary(10))) 3.insert into binarytest values(cast('aesdgA?v' as binary(10))) What should be done if I want to execute the following query? insert into binarytest values(cast(aesdg'A?v as binary(10))) Binary data : aesdg'A?v For apostrophe, the hexadecimal value is 27, decimal value is 39 This statement is required since we are actually inserting into this table through an stored procedure which we are calling in C program. In C program we are sending binary data, which may also contain apostrohpe('), comma(,), space( ) and many more characters. Regards, Shahul [quoted text, click to view] "Francesco Anti" <fanti @ sicosbt.it> wrote in message news:OUWZyMSBFHA.2192@TK2MSFTNGP14.phx.gbl... > binary data type accepts only hexadecimal values....how can you obtain an > apostrophe from an hexadecimal representation of a bit string?? > Can you post some example of your insert statement? > > Francesco Anti > > "Uma" <uma@cspl.com> wrote in message > news:us32pTRBFHA.2180@TK2MSFTNGP10.phx.gbl... > > Hi pals, > > > > I am trying to insert binary data in to a field(data type:binary) of a > > table. Facing a problem with inserting if the binary data contains > > APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the data. > > How could I insert that type of data into a binary field ? Could you > please > > guide me? > > > > regards, > > Shahul. > > > > > >
[quoted text, click to view]
in article us32pTRBFHA.2180@TK2MSFTNGP10.phx.gbl, Uma at uma@cspl.com wrote on 28-01-2005 09:45:[quoted text, click to view] > Hi pals, ge ziet ne sukel ahhahahahaha> > I am trying to insert binary data in to a field(data type:binary) of a > table. Facing a problem with inserting if the binary data contains > APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the data. > How could I insert that type of data into a binary field ? Could you please > guide me? > > regards, > Shahul. > >
Actually I need to store the Apostrophe in the binary data itself. What can I do if so? We can use the method as '''' (four apostrophe) for inserting a single apostrophe, Is any other flexible method available? I won't check the Apostrophe present in the binary data or not, when I am calling the Stored Procedure in my C program. "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in message news:e2e6quSBFHA.3940@TK2MSFTNGP09.phx.gbl... [quoted text, click to view] > Since you express the data as a string before the cast, do the same as usual, double each > single-quote: > > insert into binarytest values(cast('aesdg''A?v' as binary(10))) > > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > http://www.sqlug.se/ > > > "Uma" <uma@cspl.com> wrote in message news:OxDwgrSBFHA.136@TK2MSFTNGP14.phx.gbl... > > The following queries are working fine: > > > > create table binarytest(binfield binary(100)) > > > > 1.insert into binarytest values(cast('123' as binary(10))) > > 2.insert into binarytest values(cast(123 as binary(10))) > > 3.insert into binarytest values(cast('aesdgA?v' as binary(10))) > > > > What should be done if I want to execute the following query? > > > > insert into binarytest values(cast(aesdg'A?v as binary(10))) > > > > Binary data : aesdg'A?v > > > > For apostrophe, the hexadecimal value is 27, decimal value is 39 > > > > This statement is required since we are actually inserting into this table > > through an stored procedure which we are calling in C program. In C program > > we are sending binary data, which may also contain apostrohpe('), comma(,), > > space( ) and many more characters. > > > > Regards, > > Shahul > > > > > > > > "Francesco Anti" <fanti @ sicosbt.it> wrote in message > > news:OUWZyMSBFHA.2192@TK2MSFTNGP14.phx.gbl... > >> binary data type accepts only hexadecimal values....how can you obtain an > >> apostrophe from an hexadecimal representation of a bit string?? > >> Can you post some example of your insert statement? > >> > >> Francesco Anti > >> > >> "Uma" <uma@cspl.com> wrote in message > >> news:us32pTRBFHA.2180@TK2MSFTNGP10.phx.gbl... > >> > Hi pals, > >> > > >> > I am trying to insert binary data in to a field(data type:binary) of a > >> > table. Facing a problem with inserting if the binary data contains > >> > APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the > > data. > >> > How could I insert that type of data into a binary field ? Could you > >> please > >> > guide me? > >> > > >> > regards, > >> > Shahul. > >> > > >> > > >> > >> > > > > > >
I'm not sure what you are saying here. In your example, you express the text information as a
string, then CAST it to binary. But as you express it as a string, you need to follow the rules for string handling. Those rules are that you enclose the string within single-quotes. And if you want to express a single-quote inside the string, you escape that single-quote with another single-quote (double it). -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ http://www.sqlug.se/ [quoted text, click to view] "Uma" <uma@cspl.com> wrote in message news:uph$g00BFHA.3528@tk2msftngp13.phx.gbl... > > Actually I need to store the Apostrophe in the binary data itself. What can > I do if so? > We can use the method as '''' (four apostrophe) for inserting a single > apostrophe, Is any other flexible method available? I won't check the > Apostrophe present in the binary data or not, when I am calling the Stored > Procedure in my C program. > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in > message news:e2e6quSBFHA.3940@TK2MSFTNGP09.phx.gbl... >> Since you express the data as a string before the cast, do the same as > usual, double each >> single-quote: >> >> insert into binarytest values(cast('aesdg''A?v' as binary(10))) >> >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> http://www.sqlug.se/ >> >> >> "Uma" <uma@cspl.com> wrote in message > news:OxDwgrSBFHA.136@TK2MSFTNGP14.phx.gbl... >> > The following queries are working fine: >> > >> > create table binarytest(binfield binary(100)) >> > >> > 1.insert into binarytest values(cast('123' as binary(10))) >> > 2.insert into binarytest values(cast(123 as binary(10))) >> > 3.insert into binarytest values(cast('aesdgA?v' as binary(10))) >> > >> > What should be done if I want to execute the following query? >> > >> > insert into binarytest values(cast(aesdg'A?v as binary(10))) >> > >> > Binary data : aesdg'A?v >> > >> > For apostrophe, the hexadecimal value is 27, decimal value is 39 >> > >> > This statement is required since we are actually inserting into this > table >> > through an stored procedure which we are calling in C program. In C > program >> > we are sending binary data, which may also contain apostrohpe('), > comma(,), >> > space( ) and many more characters. >> > >> > Regards, >> > Shahul >> > >> > >> > >> > "Francesco Anti" <fanti @ sicosbt.it> wrote in message >> > news:OUWZyMSBFHA.2192@TK2MSFTNGP14.phx.gbl... >> >> binary data type accepts only hexadecimal values....how can you obtain > an >> >> apostrophe from an hexadecimal representation of a bit string?? >> >> Can you post some example of your insert statement? >> >> >> >> Francesco Anti >> >> >> >> "Uma" <uma@cspl.com> wrote in message >> >> news:us32pTRBFHA.2180@TK2MSFTNGP10.phx.gbl... >> >> > Hi pals, >> >> > >> >> > I am trying to insert binary data in to a field(data type:binary) of > a >> >> > table. Facing a problem with inserting if the binary data contains >> >> > APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the >> > data. >> >> > How could I insert that type of data into a binary field ? Could you >> >> please >> >> > guide me? >> >> > >> >> > regards, >> >> > Shahul. >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |