| Author |
How to decode a Base 64 string
|
|
| Paul Robinson 2006-01-11, 11:24 am |
| Hi,
I have a stored procedure which takes some XML as an input parameter. One
of the elements in the XML is actually an image encoded as a base 64 string.
Can anyone tell me how to decode the base 64 string so I can store the data
as a SQL Server 2000 image data type?
Thanks,
Paul
| |
| Adam Machanic 2006-01-11, 11:24 am |
| http://www.sqlservercentral.com/scr...utions/1309.asp
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Paul Robinson" <robinsonpr@aol.com> wrote in message
news:e1wh%23msFGHA.2040@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I have a stored procedure which takes some XML as an input parameter. One
> of the elements in the XML is actually an image encoded as a base 64
> string.
>
> Can anyone tell me how to decode the base 64 string so I can store the
> data
> as a SQL Server 2000 image data type?
>
> Thanks,
>
> Paul
>
>
| |
| Paul Robinson 2006-01-12, 7:23 am |
| Thanks...it docides to/from varchar fields. Can I put that straight into my
column of type "image"?
"Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message
news:%23lYW$KtFGHA.3176@TK2MSFTNGP12.phx.gbl...
> http://www.sqlservercentral.com/scr...utions/1309.asp
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
>
> "Paul Robinson" <robinsonpr@aol.com> wrote in message
> news:e1wh%23msFGHA.2040@TK2MSFTNGP14.phx.gbl...
One[color=darkred]
>
>
| |
| Adam Machanic 2006-01-12, 8:24 pm |
| See if this thread helps you:
http://groups.google.com/group/micr...5b5186
c6
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Paul Robinson" <robinsonpr@aol.com> wrote in message
news:efrmt62FGHA.3728@tk2msftngp13.phx.gbl...
> Thanks...it docides to/from varchar fields. Can I put that straight into
> my
> column of type "image"?
>
>
> "Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message
> news:%23lYW$KtFGHA.3176@TK2MSFTNGP12.phx.gbl...
> One
>
>
|
|
|
|