Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing XML in SQLServer text field
Message
 
 
To
24/10/2006 09:21:50
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
01164004
Message ID:
01164082
Views:
10
This message has been marked as the solution to the initial question of the thread.
No, she wants to store XML as is not to load data from it into a table(s). The image column would be the best because it's not affected by code page translation but it's hard to handle with SPT in pre-VFP9. The text will next best choice but the code page translation code be a problem.

>Oops, thanks Sergey. I'm guessing she probably needs to do something like:
>
>http://support.microsoft.com/kb/316005
>
>
>>Hi Tracy,
>>
>>The BLOB and CLOB are not MS SQL Server data types. The Image, Text and Ntext are.
>>
>>
>>>You can create a BLOB or CLOB column and insert the whole xml to the column. Not the ideal way though I don't think. You might want to read this first for another option:
>>>
>>>http://www.samspublishing.com/articles/article.asp?p=99813&rl=1
>>>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform