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-"'
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
