Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mabel
Starting Member
4 Posts |
 Posted - 2010-12-29 : 00:34:52
|
| Hi all,I have a column of BLOB data type in a table.The text is stored as blob format in this field when entered through front end(this is done through ERP applications)Now the issue is that i need to update the blob field through back end.The input i have is the simple text.I need to convert this text to blob data type and insert it through sql.We are using sql server 2005.can any one help me with this.Thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-29 : 01:44:25
|
| There is no such thing as "blob" datatype.What is the exact datatype you are using ?PBUH |
 |
|
|
mabel
Starting Member
4 Posts |
Posted - 2011-01-03 : 11:49:03
|
| If it is not blob then it is hexadecimal or rich text .can you pleaes let me know how to convert text to rtf format or hexa decimal format.Thanks. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-01-03 : 18:47:34
|
| You can use the CAST or CONVERT functions but you'll still need to know, as Sachin.Nand pointed out, the exact datatype you are using. Also, there is no RTF datatype.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-01-04 : 04:28:32
|
| "If it is not blob then it is hexadecimal or rich text"There is no hexadecimal or rich text datatype in SQL either.Just find out what type it is otherwise we can't be any help.Most likely it is TEXT / Ntext or IMAGE datatype if you are encountering problems.If you need to manipulate the data it would easier if you changed the datatype to VARCHAR(MAX) or Nvarchar(MAX) (introduced in SQL2005) - but that may not be possible if this is a 3rd party application - but if the datatype is the (now deprecated) TEXT or IMAGE it is worth checking if an upgrade is available to the application as TEXT / IMAGE datatypes are a PITA to manipulate (by comparison to the newer VARCHAR(MAX) ) |
|
|
|
|
|
|
Inserting text in BLOB Field