Option strings

The option string of a for xml clause can specify a u& form of literal, and then contain the SQL notation for characters. Then you can specify Unicode characters for the rowname, tablename, and prefix options. For example, enter:

select * from T
for xml
options u&'tablename = \0415\0416 rowname =
           \+01d6d prefix = \0622'

If a specified tablename, rowname, or prefix option contains characters that are not valid in simple identifiers, you must specify the option as a quoted identifier. For example, enter:

select * from T
for xml
optons u&'tablename = "chars\0415 and \0416"
     rowname = "\+01d6d1 & \+01d160" 
     prefix = "\0622-"'