>>In a SQL Server table there is a field that will hold an XML string. In VFP the field type would be Memo. What should it be in SQL Server?
>>
>>I am guessing varchar or nvarchar, which leads to the next question. In order to allow as many of our clients to use SQL Server Express Edition rather than the full product I'd prefer to use varchar rather than nvarchar. The stored XML is meant to hold a set of properties with their values. We control the name of the properties and can make sure their names and values don't use any "strange" characters such as the spanish ñ or á etc, but I need to be sure if the control characters used by XML are the same in all Latin codepages. The characters I mean are < > / and any others used in normal XML but of which I am not aware yet.
>>
>>Does someone know the answer? TIA,
>>
>>Alex
>
>If it's SQL2005 (saying express edition I assume 2005), than SQL datatype is XML.
>Control characters are same in all languages AFAIK.
>Cetin

Thank you, that is a very good lead. I was modeling the database in our main server, which has SQL Server 8.0 so I didn't see that option.

Alex