


Detailed introduction to the case of testing several xml problems
When using sql server, it is inevitable to deal with xml parameters. xml brings convenience to our programs most of the time, but there are also times when variable assignment fails. (Of course, if your own xml cannot pass the inspection of software such as xml spy, then this is not the scope of this aspect~)
The examples shared today are very simple, just test a few examples
DECLARE @x XML SELECT @x = '<a>1</a>' SELECT @x = '<?xml version="1.0" encoding="utf-8"?> <a>1</a> ' SELECT @x = N'<?xml version="1.0" encoding="utf-8"?> <a>1</a> ' SELECT @x = '<?xml version="1.0" encoding="utf-8"?> <a>一个人</a> ' SELECT @x = '<?xml version="1.0" encoding="GBK"?> <a>单身狗汪</a>
Example 1:
This is the most common example we see, and it can be compiled without any pressure. The variable assignment passed, and then the query, parsing, whatever you want~
Example 2:
The compilation also passed. It seems that this is the most likely place to cause misunderstandings. I always thought that sql server The assignment inside does not support headers like
<?xml version="1.0" encoding="utf-8"?>
, so I usually tell the coder that if such an error occurs, just remove the header (it will indeed work, but the reason is wrong (⊙ ﹏⊙)b). In fact, the XML type itself is supported, but it is just a matter of application scenarios when we call stored procedures or assign parameters in statements. sql server said that I will not bear this responsibility
Example 3:
There is a problem in compiling this example, and the compiler throws
Message 9402, level 16, status 1 , Line 8
XML analysis: Line 1, character 38, encoding cannot be switched
However, the difference between Example 3 and Example 2 is that the assignment in Example 3 uses unicode encoding, while Example 2 does not. Do it, so in Example 3, I fell to my knees instantly ╮(╯_╰)╭. Therefore, the database parameter transfer errors we usually find are because this method is used, so I have been fooled_(:з」∠)_. So it’s not that it’s not supported, it’s just that there’s a problem with our calling method
Example 4:
Message 9420, level 16, status 1, line 9
XML analysis: line 2, character 5. Illegal xml characters
Hey~ Another error is reported~ This time it is an illegal xml character. It seems that the encoding is utf-8, which does not support Chinese. So sometimes if you don’t pay attention to these details, it’s really.../(ㄒoㄒ)/~~
Example 5:
The compilation passed successfully, this time the encoding inside was changed to GBK encoding, It can support Chinese. Of course, compilation is no problem at all.
To add another example
SELECT @x = '<?xml version="1.0" encoding="GBK"?> <a>繁体字 龍 _(:з」∠)_</a>
is also ok. Some traditional Chinese characters are also supported in the GBK font library, and generally there is no need to worry about this issue. Unless there are some special symbols, it’s hard to say haha
Finally, encoding="utf-8" and encoding="UTF-8" are equivalent, and there is no case sensitivity here. Note that here...
The above is the detailed content of Detailed introduction to the case of testing several xml problems. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Can XML files be opened with PPT? XML, Extensible Markup Language (Extensible Markup Language), is a universal markup language that is widely used in data exchange and data storage. Compared with HTML, XML is more flexible and can define its own tags and data structures, making the storage and exchange of data more convenient and unified. PPT, or PowerPoint, is a software developed by Microsoft for creating presentations. It provides a comprehensive way of

Using Python to merge and deduplicate XML data XML (eXtensibleMarkupLanguage) is a markup language used to store and transmit data. When processing XML data, sometimes we need to merge multiple XML files into one, or remove duplicate data. This article will introduce how to use Python to implement XML data merging and deduplication, and give corresponding code examples. 1. XML data merging When we have multiple XML files, we need to merge them

Convert XML data in Python to CSV format XML (ExtensibleMarkupLanguage) is an extensible markup language commonly used for data storage and transmission. CSV (CommaSeparatedValues) is a comma-delimited text file format commonly used for data import and export. When processing data, sometimes it is necessary to convert XML data to CSV format for easy analysis and processing. Python is a powerful

Implementing filtering and sorting of XML data using Python Introduction: XML is a commonly used data exchange format that stores data in the form of tags and attributes. When processing XML data, we often need to filter and sort the data. Python provides many useful tools and libraries to process XML data. This article will introduce how to use Python to filter and sort XML data. Reading the XML file Before we begin, we need to read the XML file. Python has many XML processing libraries,

Importing XML data into the database using PHP Introduction: During development, we often need to import external data into the database for further processing and analysis. As a commonly used data exchange format, XML is often used to store and transmit structured data. This article will introduce how to use PHP to import XML data into a database. Step 1: Parse the XML file First, we need to parse the XML file and extract the required data. PHP provides several ways to parse XML, the most commonly used of which is using Simple

Python implements conversion between XML and JSON Introduction: In the daily development process, we often need to convert data between different formats. XML and JSON are common data exchange formats. In Python, we can use various libraries to convert between XML and JSON. This article will introduce several commonly used methods, with code examples. 1. To convert XML to JSON in Python, we can use the xml.etree.ElementTree module

Handling Errors and Exceptions in XML Using Python XML is a commonly used data format used to store and represent structured data. When we use Python to process XML, sometimes we may encounter some errors and exceptions. In this article, I will introduce how to use Python to handle errors and exceptions in XML, and provide some sample code for reference. Use try-except statement to catch XML parsing errors When we use Python to parse XML, sometimes we may encounter some

Python parses special characters and escape sequences in XML XML (eXtensibleMarkupLanguage) is a commonly used data exchange format used to transfer and store data between different systems. When processing XML files, you often encounter situations that contain special characters and escape sequences, which may cause parsing errors or misinterpretation of the data. Therefore, when parsing XML files using Python, we need to understand how to handle these special characters and escape sequences. 1. Special characters and
