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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-24 : 08:38:34
|
| Mark writes "We have an oline application form, which allows people to apply for vacancies online. The user can also attach a coverletter, which is saved in Rich Text Format.The coverletter is stored in the database as an image type and looks and is displayed as <binary> in the field. I need to interpret the field so its shows as the rtf string in a view i.e. <rtf1 etc.I have used the statement below.CAST(CAST(displaycv as varbinary(8000)) As varchar(8000)) as CVThis works but for letters under 8000, but obviously cuts off letters over 8000. I have used Datalength to measure the size of the letters and some go over 50000.I am now stuck as I need the full string to pass to a reporting package, Crystal Reports. Crystal cannot intepret the data as it is, i.e. an imagetype and needs to be converted.Can you help in trying to extract the whole of the dataThanksMark" |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-24 : 08:52:53
|
| Is the data Binary? or actually only ASCII text (which RTF would be)?If so maybe you could change the column datatype from IMAGE to TEXT and maybe Crystal reports would be happy with that?Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Extracting all data from a field