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 |
|
p.balazs
Starting Member
3 Posts |
 Posted - 2007-01-10 : 10:32:27
|
| Hi!How can I export an image type field (which contains text!) from a table to a text.file?Now it converts it to Hex characters like "000D000A0065"Thanks! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-10 : 10:39:09
|
| Obviously it's going to show hex values since the image data type stores binary data even though you are storing text in it.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
p.balazs
Starting Member
3 Posts |
Posted - 2007-01-10 : 11:24:03
|
| Ok, it's normal.The question is, that how can export the image field to readable text.ThanksBalazs |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-10 : 12:09:36
|
| Convert the IMAGE to hex characters in the file, and convert back to binary when importing.Peter LarssonHelsingborg, Sweden |
|
|
|
p.balazs
Starting Member
3 Posts |
Posted - 2007-01-10 : 12:20:35
|
| All that I want: to read the text.(This is "script" table of the MOM 2005 "Onepoint" database. I want to find a string to detect the name of the script which contains it. From MOM console I can find only for the name of the script. The body is in the image field.)Balazs, Hungary |
|
|
|
|
|
|
Howto Export image type field to text file