Internet Engineering Task Force (IETF) Y. Shafranovich Request for Comments: 6922 BioFortis, Inc. Category: Informational April 2013 ISSN: 2070-1721
Internet Engineering Task Force (IETF) Y. Shafranovich Request for Comments: 6922 BioFortis, Inc. Category: Informational April 2013 ISSN: 2070-1721
The application/sql Media Type
应用程序/sql媒体类型
Abstract
摘要
This document registers the application/sql media type to be used for the Structured Query Language (SQL).
本文档注册用于结构化查询语言(sql)的应用程序/sql媒体类型。
Status of This Memo
关于下段备忘
This document is not an Internet Standards Track specification; it is published for informational purposes.
本文件不是互联网标准跟踪规范;它是为了提供信息而发布的。
This document is a product of the Internet Engineering Task Force (IETF). It represents the consensus of the IETF community. It has received public review and has been approved for publication by the Internet Engineering Steering Group (IESG). Not all documents approved by the IESG are a candidate for any level of Internet Standard; see Section 2 of RFC 5741.
本文件是互联网工程任务组(IETF)的产品。它代表了IETF社区的共识。它已经接受了公众审查,并已被互联网工程指导小组(IESG)批准出版。并非IESG批准的所有文件都适用于任何级别的互联网标准;见RFC 5741第2节。
Information about the current status of this document, any errata, and how to provide feedback on it may be obtained at http://www.rfc-editor.org/info/rfc6922.
有关本文件当前状态、任何勘误表以及如何提供反馈的信息,请访问http://www.rfc-editor.org/info/rfc6922.
Copyright Notice
版权公告
Copyright (c) 2013 IETF Trust and the persons identified as the document authors. All rights reserved.
版权所有(c)2013 IETF信托基金和确定为文件作者的人员。版权所有。
This document is subject to BCP 78 and the IETF Trust's Legal Provisions Relating to IETF Documents (http://trustee.ietf.org/license-info) in effect on the date of publication of this document. Please review these documents carefully, as they describe your rights and restrictions with respect to this document. Code Components extracted from this document must include Simplified BSD License text as described in Section 4.e of the Trust Legal Provisions and are provided without warranty as described in the Simplified BSD License.
本文件受BCP 78和IETF信托有关IETF文件的法律规定的约束(http://trustee.ietf.org/license-info)自本文件出版之日起生效。请仔细阅读这些文件,因为它们描述了您对本文件的权利和限制。从本文件中提取的代码组件必须包括信托法律条款第4.e节中所述的简化BSD许可证文本,并提供简化BSD许可证中所述的无担保。
Table of Contents
目录
1. Introduction . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Conventions Used in This Document . . . . . . . . . . . . . . . 2 3. Media Type Registration Application . . . . . . . . . . . . . . 2 4. IANA Considerations . . . . . . . . . . . . . . . . . . . . . . 4 5. Security Considerations . . . . . . . . . . . . . . . . . . . . 4 6. Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . 4 7. Normative References . . . . . . . . . . . . . . . . . . . . . 5
1. Introduction . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Conventions Used in This Document . . . . . . . . . . . . . . . 2 3. Media Type Registration Application . . . . . . . . . . . . . . 2 4. IANA Considerations . . . . . . . . . . . . . . . . . . . . . . 4 5. Security Considerations . . . . . . . . . . . . . . . . . . . . 4 6. Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . 4 7. Normative References . . . . . . . . . . . . . . . . . . . . . 5
The Structured Query Language (SQL) has been in use for over 30 years with various types of database technologies. However, there is no current media type registered for SQL. Therefore, this document seeks to formally register the application/sql media type to be used for SQL with IANA.
结构化查询语言(SQL)已经在各种类型的数据库技术中使用了30多年。但是,没有为SQL注册的当前媒体类型。因此,本文档旨在向IANA正式注册用于sql的应用程序/sql介质类型。
The key words "MUST", "MUST NOT", "REQUIRED", "SHALL", "SHALL NOT", "SHOULD", "SHOULD NOT", "RECOMMENDED", "MAY", and "OPTIONAL" in this document are to be interpreted as described in [RFC2119] when they appear in ALL CAPS. These words may also appear in this document in lowercase as English prose, absent of the normative meanings mentioned above.
本文件中的关键词“必须”、“不得”、“要求”、“应”、“不得”、“应”、“不应”、“建议”、“可”和“可选”在所有大写字母中出现时,应按照[RFC2119]中的说明进行解释。这些词语也可能以英文散文形式以小写形式出现在本文件中,不具有上述规范性含义。
This section provides the media type registration application for this media type (see [RFC6838], Section 5.6)
本节提供了该介质类型的介质类型注册应用程序(见[RFC6838],第5.6节)
Type name: application
类型名称:应用程序
Subtype name: sql
子类型名称:sql
Required parameters: N/A
所需参数:不适用
Optional parameters:
可选参数:
"charset" -- indicates the character set to be used. When not specified, a default value MUST NOT be assumed without inspection of the content.
“字符集”--表示要使用的字符集。未指定时,在未检查内容的情况下,不得假定默认值。
Implementors should be aware that SQL may carry character set information in-band. In such cases, the "charset" parameter MUST NOT be used in order to avoid conflict. In cases where no character set information is supplied in-band, and the character
实现者应该知道,SQL可能在频带中携带字符集信息。在这种情况下,不得使用“charset”参数以避免冲突。在频带中未提供字符集信息的情况下
set is known, implementors SHOULD use the "charset" parameter. If no in-band or out-of-band character set information is available, implementors MUST NOT specify the "charset" parameter.
如果已知该集合,则实现者应使用“charset”参数。如果没有带内或带外字符集信息可用,则实现者不得指定“charset”参数。
Encoding considerations:
编码注意事项:
If the "charset" parameter is used, the corresponding 7-bit, 8-bit, or binary encoding may be used. If the "charset" parameter is not used, binary encoding may be required.
如果使用“charset”参数,则可以使用相应的7位、8位或二进制编码。如果未使用“charset”参数,则可能需要二进制编码。
Security considerations:
安全考虑:
Being that SQL is a full-fledged programming language and may include embedded source code for other programming languages, there is a risk of it being used to transfer malware, viruses, and other malicious payloads. Implementors and users are encouraged only to exchange SQL files among trusted parties and utilize all available security measures, such as restricted access, virus scanners, etc., to minimize risk.
由于SQL是一种成熟的编程语言,可能包含其他编程语言的嵌入式源代码,因此它有被用于传输恶意软件、病毒和其他恶意有效负载的风险。我们鼓励实施者和用户仅在受信任方之间交换SQL文件,并利用所有可用的安全措施,如限制访问、病毒扫描等,以将风险降至最低。
Implementors should be aware that guessing character sets, encodings, and possible conflicts between in-band and out-of-band character set information may lead to the similar security issues as described above.
实现者应该知道,猜测字符集、编码以及带内和带外字符集信息之间可能存在的冲突可能会导致上述类似的安全问题。
Implementors should also be aware that SQL does not provide or guarantee any sort of confidentiality and integrity checking, and SQL files can expose account information or private information about database structure and contents. It is therefore important for applications to provide confidentiality and protection against modification by malicious third parties while in transit.
实现者还应该知道,SQL不提供或保证任何类型的机密性和完整性检查,SQL文件可以公开帐户信息或有关数据库结构和内容的私有信息。因此,对于应用程序来说,在传输过程中提供机密性和防止恶意第三方修改非常重要。
Interoperability considerations:
互操作性注意事项:
While a single standard exists ([ISO.9075.2011]), vendor implementations of the standard vary significantly. Implementors and users should make sure that the exchanged SQL files match to the specific database/tool and version that they are using.
虽然存在单一标准([ISO.9075.2011]),但供应商对该标准的实施情况差异很大。实现者和用户应该确保交换的SQL文件与他们使用的特定数据库/工具和版本相匹配。
Published specification:
已发布的规范:
The most recent specification of SQL is available in [ISO.9075.2011].
SQL的最新规范见[ISO.9075.2011]。
Applications that use this media type:
使用此媒体类型的应用程序:
Databases and related tools
数据库和相关工具
Fragment identifier considerations: N/A
片段标识符注意事项:不适用
Additional information:
其他信息:
Deprecated alias names for this type: N/A
此类型的已弃用别名:不适用
Magic number(s): N/A
Magic number(s): N/A
File extension(s): sql
文件扩展名:sql
Macintosh File Type Code(s): N/A
Macintosh File Type Code(s): N/A
Person & email address to contact for further information:
联系人和电子邮件地址,以获取更多信息:
Yakov Shafranovich <ietf@shaftek.org>
Yakov Shafranovich <ietf@shaftek.org>
Intended usage: COMMON
预期用途:普通
Restrictions on usage: N/A
使用限制:不适用
Author: IESG
作者:IESG
Change controller: IESG
更改控制器:IESG
Provisional registration? (standards tree only): N/A
临时登记?(仅限标准树):不适用
IANA has registered "application/sql" in the standards tree of the "Application Media Types" registry, using the application provided in Section 3 of this document.
IANA已使用本文件第3节中提供的应用程序在“应用程序媒体类型”注册表的标准树中注册了“应用程序/sql”。
See the Security Considerations item in the registration template in Section 3, above.
请参见上文第3节注册模板中的安全注意事项项。
To LTS, thanks for everything.
谢谢你所做的一切。
The author would also like to thank all of the folks at xml.resource.org for providing many of the tools used for preparing RFCs and Internet-Drafts.
作者还要感谢xml.resource.org上的所有人,他们提供了许多用于准备RFC和Internet草稿的工具。
A word of thanks to all IETF members who provided feedback on this document.
感谢所有就本文件提供反馈的IETF成员。
[ISO.9075.2011] International Organization for Standardization, "ISO/IEC 9075:2011, Information Technology - Database Languages - Structured Query Language (SQL)", 2011.
[ISO.9075.2011]国际标准化组织,“ISO/IEC 9075:2011,信息技术-数据库语言-结构化查询语言(SQL)”,2011年。
[RFC2119] Bradner, S., "Key words for use in RFCs to Indicate Requirement Levels", BCP 14, RFC 2119, March 1997.
[RFC2119]Bradner,S.,“RFC中用于表示需求水平的关键词”,BCP 14,RFC 2119,1997年3月。
[RFC6838] Freed, N., Klensin, J., and T. Hansen, "Media Type Specifications and Registration Procedures", BCP 13, RFC 6838, January 2013.
[RFC6838]Freed,N.,Klensin,J.和T.Hansen,“媒体类型规范和注册程序”,BCP 13,RFC 6838,2013年1月。
Author's Address
作者地址
Yakov Shafranovich BioFortis, Inc. 10320 Little Patuxent Parkway, Suite 410 Columbia, MD 21044 US
Yakov Shafranovich BioFortis,Inc.美国马里兰州哥伦比亚市小帕塔克森特大道10320号410室21044
Phone: +1 443 276-2464 EMail: ietf@shaftek.org
Phone: +1 443 276-2464 EMail: ietf@shaftek.org