Requirements and limitations for Amazon RDS Custom for SQL Server
Following, you can find a summary of the Amazon RDS Custom for SQL Server requirements and limitations for quick reference. Requirements and limitations also appear in the relevant sections.
Topics
- Region and version availability
- General requirements for RDS Custom for SQL Server
- DB instance class support for RDS Custom for SQL Server
- Limitations for RDS Custom for SQL Server
- Collation and character support for RDS Custom for SQL Server DB instances
- Local time zone for RDS Custom for SQL Server DB instances
- Using a Service Master Key with RDS Custom for SQL Server
Region and version availability
Feature availability and support varies across specific versions of each database engine, and across AWS Regions. For more information on version and Region availability of Amazon RDS with Amazon RDS Custom for SQL Server, see RDS Custom for SQL Server.
General requirements for RDS Custom for SQL Server
Make sure to follow these requirements for Amazon RDS Custom for SQL Server:
-
Use the instance classes shown in DB instance class support for RDS Custom for SQL Server. The only storage types supported are solid state drives (SSD) of types gp2, gp3, io1, and io2 Block Express. The maximum storage limit is 16 TiB.
-
Make sure that you have a symmetric encryption AWS KMS key to create an RDS Custom DB instance. For more information, see Make sure that you have a symmetric encryption AWS KMS key.
-
Make sure that you create an AWS Identity and Access Management (IAM) role and instance profile. For more information, see Creating your IAM role and instance profile manually.
-
Make sure to supply a networking configuration that RDS Custom can use to access other AWS services. For specific requirements, see Configure networking, instance profile, and encryption.
-
The combined number of RDS Custom and Amazon RDS DB instances can't exceed your quota limit. For example, if your quota is 40 DB instances, you can have 20 RDS Custom for SQL Server DB instances and 20 Amazon RDS DB instances.
DB instance class support for RDS Custom for SQL Server
Check if the DB instance class is supported in your Region by using the
describe-orderable-db-instance-options
RDS Custom for SQL Server supports the DB instance classes shown in the following table:
| SQL Server edition | RDS Custom support |
|---|---|
|
Enterprise Edition |
db.r5.xlarge–db.r5.24xlarge db.r5b.xlarge–db.r5b.24xlarge db.m5.xlarge–db.m5.24xlarge db.r6i.xlarge–db.r6i.32xlarge db.m6i.xlarge–db.m6i.32xlarge db.x2iedn.xlarge–db.x2iedn.32xlarge |
|
Standard Edition |
db.r5.large–db.r5.24xlarge db.r5b.large–db.r5b.8xlarge db.m5.large–db.m5.24xlarge db.r6i.large–db.r6i.8xlarge db.m6i.large–db.m6i.8xlarge db.x2iedn.xlarge–db.x2iedn.8xlarge |
|
Developer Edition |
db.r5.xlarge–db.r5.24xlarge db.r5b.xlarge–db.r5b.24xlarge db.m5.xlarge–db.m5.24xlarge db.r6i.xlarge–db.r6i.32xlarge db.m6i.xlarge–db.m6i.32xlarge db.x2iedn.xlarge–db.x2iedn.32xlarge |
|
Web Edition |
db.r5.large–db.r5.4xlarge db.m5.large–db.m5.4xlarge db.r6i.large–db.r6i.4xlarge db.m6i.large–db.m6i.4xlarge db.r5b.large–db.r5b.4xlarge |
The following recommendations apply to db.x2iedn class types:
-
At creation, local storage is a raw and unallocated device. Before using a DB instance with this instance class, you must mount and format the local storage. Afterward, configure
tempdbon it to ensure optimal performance. For more information, see Optimize tempdb performance in Amazon RDS Custom for SQL Server using local instance storage. -
Local storage reverts to its raw and unallocated state when you run DB instance operations such as scale compute, instance replacement, snapshot restore, or point-in-time recovery (PITR). In these situations, you must remount, reformat, and reconfigure the drive and
tempdbto restore functionality. -
For Multi-AZ instances, we recommend that you perform the configuration on a standby DB instance. This way, if a failover occurs, the system continues to operate without issues because the configuration is already in place on the standby instance.
Limitations for RDS Custom for SQL Server
The following limitations apply to RDS Custom for SQL Server:
-
You can't create read replicas in Amazon RDS for RDS Custom for SQL Server DB instances. However, you can configure high availability automatically with a Multi-AZ deployment. For more information, see Managing a Multi-AZ deployment for RDS Custom for SQL Server.
-
You can't modify the DB instance identifier of an existing RDS Custom for SQL Server DB instance.
-
For an RDS Custom for SQL Server DB instance that wasn't created with a custom engine version (CEV), changes to the Microsoft Windows operating system aren't guaranteed to persist. For example, you lose these changes when you initiate a snapshot or point-in-time restore operation. If the RDS Custom for SQL Server DB instance was created with a CEV, then those changes are persisted.
-
Not all options are supported. For example, when you create an RDS Custom for SQL Server DB instance, you can't do the following:
-
Change the number of CPU cores and threads per core on the DB instance class.
-
Turn on storage autoscaling.
-
Configure Kerberos authentication using the AWS Management Console. However, you can configure Windows Authentication manually and use Kerberos.
-
Specify your own DB parameter group, option group, or character set.
-
Turn on Performance Insights.
-
Turn on automatic minor version upgrade.
-
-
The maximum DB instance storage is 16 TiB.
Collation and character support for RDS Custom for SQL Server DB instances
RDS Custom for SQL Server supports a wide range of server collations, both in traditional and UTF-8 encoding, for the SQL_Latin, Japanese, German, and Arabic locales.
The default server collation is SQL_Latin1_General_CP1_CI_AS, however, you can select another supported collation to use. You can select
a collation using the same procedure that RDS for SQL Server uses. For more information, see
Collations and character
sets for Microsoft SQL Server.
The following requirements and limitations apply when working with server collations on RDS Custom for SQL Server:
You can set the server collation when you create an RDS Custom for SQL Server DB instance. You can't modify the server-level collation after the DB instance is created.
You can't modify the server level collation when restoring from a DB snapshot or during a point in time recovery (PITR).
When you create a DB instance from an RDS Custom for SQL Server CEV, the DB instance doesn't inherit the server collation from the CEV. Instead, the default server collation of
SQL_Latin1_General_CP1_CI_ASis used. If you've configured a non-default server collation on a RDS Custom for SQL Server CEV and want to use that same server collation on a new DB instance, be sure to select that same collation when you create the DB instance from the CEV.Note
If the collation you select while creating the DB instance is different from the collation of the CEV, the Microsoft SQL Server system databases on the new RDS Custom for SQL Server DB instance will be rebuilt to use the updated collation. The rebuild process is only performed on the new RDS Custom for SQL Server DB instance and has no impact on the CEV itself. Any previous modifications that you made to the system databases on the CEV will not be retained on the new RDS Custom for SQL Server DB instance once the system databases are rebuilt. Examples of some modifications include user-defined objects in the
masterdatabase, scheduled jobs in themsdbdatabase, or changes to default database settings in themodeldatabase on your CEV. You can manually recreate your modifications once the new RDS Custom for SQL Server DB instance is created.When you create a DB instance from an RDS Custom for SQL Server custom engine version (CEV) and select a different collation from that of the CEV, ensure that your golden image (AMI) used for CEV creation meets the following requirements so the Microsoft SQL Server system databases on the new DB instance can be rebuilt:
For SQL Server 2022, ensure the
setup.exefile is located in the following path:C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\SQL2022\setup.exeFor SQL Server 2019, ensure the
setup.exefile is located in the following path:C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019\setup.exeCopies of the data and log templates for the
master,model, andmsdbdatabases must exist in their default locations. For more information, see Rebuild system databasesin the Microsoft public documentation. Ensure your SQL Server Database Engine uses
NT Service\MSSQLSERVERorNT AUTHORITY\NETWORK SERVICEas the service account. Any other account will not have the required permissions on theC:\drive when configuring a non-default server collation for the DB instance.
If the server collation selected for a new DB instance is the same as that configured on your CEV, the Microsoft SQL Server system databases on the new RDS Custom for SQL Server DB instance do not undergo the rebuild process. Any previous modifications that you made to the system databases on the CEV will automatically persist to the new RDS Custom for SQL Server DB instance.
You can set your collation to one of the values listed in the following table.
| Server Collation | Description |
| Arabic_100_BIN | Arabic-100, binary sort |
| Arabic_100_BIN2 | Arabic-100, binary code point comparison sort |
| Arabic_100_CI_AI | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Arabic_100_CI_AI_KS | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Arabic_100_CI_AI_KS_SC | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Arabic_100_CI_AI_KS_SC_UTF8 | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Arabic_100_CI_AI_KS_WS | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_CI_AI_KS_WS_SC | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Arabic_100_CI_AI_KS_WS_SC_UTF8 | Arabic-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Arabic_100_CI_AI_SC | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Arabic_100_CI_AI_SC_UTF8 | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Arabic_100_CI_AI_WS | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Arabic_100_CI_AI_WS_SC | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Arabic_100_CI_AI_WS_SC_UTF8 | Arabic-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Arabic_100_CI_AS | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Arabic_100_CI_AS_KS | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Arabic_100_CI_AS_KS_SC | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Arabic_100_CI_AS_KS_SC_UTF8 | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Arabic_100_CI_AS_KS_WS | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_CI_AS_KS_WS_SC | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Arabic_100_CI_AS_KS_WS_SC_UTF8 | Arabic-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Arabic_100_CI_AS_SC | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Arabic_100_CI_AS_SC_UTF8 | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Arabic_100_CI_AS_WS | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Arabic_100_CI_AS_WS_SC | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Arabic_100_CI_AS_WS_SC_UTF8 | Arabic-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Arabic_100_CS_AI | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Arabic_100_CS_AI_KS | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Arabic_100_CS_AI_KS_SC | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Arabic_100_CS_AI_KS_SC_UTF8 | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Arabic_100_CS_AI_KS_WS | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_CS_AI_KS_WS_SC | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Arabic_100_CS_AI_KS_WS_SC_UTF8 | Arabic-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Arabic_100_CS_AI_SC | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Arabic_100_CS_AI_SC_UTF8 | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Arabic_100_CS_AI_WS | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Arabic_100_CS_AI_WS_SC | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Arabic_100_CS_AI_WS_SC_UTF8 | Arabic-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Arabic_100_CS_AS | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Arabic_100_CS_AS_KS | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Arabic_100_CS_AS_KS_SC | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Arabic_100_CS_AS_KS_SC_UTF8 | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Arabic_100_CS_AS_KS_WS | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Arabic_100_CS_AS_KS_WS_SC | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Arabic_100_CS_AS_KS_WS_SC_UTF8 | Arabic-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Arabic_100_CS_AS_SC | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Arabic_100_CS_AS_SC_UTF8 | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Arabic_100_CS_AS_WS | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Arabic_100_CS_AS_WS_SC | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Arabic_100_CS_AS_WS_SC_UTF8 | Arabic-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Arabic_BIN | Arabic, binary sort |
| Arabic_BIN2 | Arabic, binary code point comparison sort |
| Arabic_CI_AI | Arabic, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Arabic_CI_AI_KS | Arabic, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Arabic_CI_AI_KS_WS | Arabic, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Arabic_CI_AI_WS | Arabic, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Arabic_CI_AS | Arabic, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Arabic_CI_AS_KS | Arabic, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Arabic_CI_AS_KS_WS | Arabic, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Arabic_CI_AS_WS | Arabic, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Arabic_CS_AI | Arabic, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Arabic_CS_AI_KS | Arabic, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Arabic_CS_AI_KS_WS | Arabic, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Arabic_CS_AI_WS | Arabic, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Arabic_CS_AS | Arabic, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Arabic_CS_AS_KS | Arabic, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Arabic_CS_AS_KS_WS | Arabic, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Arabic_CS_AS_WS | Arabic, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Chinese_PRC_BIN2 | Chinese-PRC, binary code point comparison sort |
| Chinese_PRC_CI_AS | Chinese-PRC, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Chinese_Taiwan_Stroke_CI_AS | Chinese-Taiwan-Stroke, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Danish_Norwegian_CI_AS | Danish-Norwegian, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Finnish_Swedish_CI_AS | Finnish-Swedish, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| French_CI_AS | French, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_100_BIN | German-PhoneBook-100, binary sort |
| German_PhoneBook_100_BIN2 | German-PhoneBook-100, binary code point comparison sort |
| German_PhoneBook_100_CI_AI | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_100_CI_AI_KS | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| German_PhoneBook_100_CI_AI_KS_SC | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| German_PhoneBook_100_CI_AI_KS_SC_UTF8 | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CI_AI_KS_WS | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| German_PhoneBook_100_CI_AI_KS_WS_SC | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| German_PhoneBook_100_CI_AI_KS_WS_SC_UTF8 | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CI_AI_SC | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| German_PhoneBook_100_CI_AI_SC_UTF8 | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CI_AI_WS | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| German_PhoneBook_100_CI_AI_WS_SC | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| German_PhoneBook_100_CI_AI_WS_SC_UTF8 | German-PhoneBook-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CI_AS | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_100_CI_AS_KS | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| German_PhoneBook_100_CI_AS_KS_SC | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| German_PhoneBook_100_CI_AS_KS_SC_UTF8 | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CI_AS_KS_WS | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| German_PhoneBook_100_CI_AS_KS_WS_SC | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| German_PhoneBook_100_CI_AS_KS_WS_SC_UTF8 | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CI_AS_SC | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| German_PhoneBook_100_CI_AS_SC_UTF8 | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CI_AS_WS | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| German_PhoneBook_100_CI_AS_WS_SC | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| German_PhoneBook_100_CI_AS_WS_SC_UTF8 | German-PhoneBook-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CS_AI | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_100_CS_AI_KS | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| German_PhoneBook_100_CS_AI_KS_SC | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| German_PhoneBook_100_CS_AI_KS_SC_UTF8 | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CS_AI_KS_WS | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| German_PhoneBook_100_CS_AI_KS_WS_SC | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| German_PhoneBook_100_CS_AI_KS_WS_SC_UTF8 | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CS_AI_SC | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| German_PhoneBook_100_CS_AI_SC_UTF8 | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CS_AI_WS | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| German_PhoneBook_100_CS_AI_WS_SC | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| German_PhoneBook_100_CS_AI_WS_SC_UTF8 | German-PhoneBook-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CS_AS | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_100_CS_AS_KS | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| German_PhoneBook_100_CS_AS_KS_SC | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| German_PhoneBook_100_CS_AS_KS_SC_UTF8 | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CS_AS_KS_WS | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| German_PhoneBook_100_CS_AS_KS_WS_SC | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| German_PhoneBook_100_CS_AS_KS_WS_SC_UTF8 | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CS_AS_SC | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| German_PhoneBook_100_CS_AS_SC_UTF8 | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| German_PhoneBook_100_CS_AS_WS | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| German_PhoneBook_100_CS_AS_WS_SC | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| German_PhoneBook_100_CS_AS_WS_SC_UTF8 | German-PhoneBook-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| German_PhoneBook_BIN | German-PhoneBook, binary sort |
| German_PhoneBook_BIN2 | German-PhoneBook, binary code point comparison sort |
| German_PhoneBook_CI_AI | German-PhoneBook, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_CI_AI_KS | German-PhoneBook, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| German_PhoneBook_CI_AI_KS_WS | German-PhoneBook, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| German_PhoneBook_CI_AI_WS | German-PhoneBook, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| German_PhoneBook_CI_AS | German-PhoneBook, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_CI_AS_KS | German-PhoneBook, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| German_PhoneBook_CI_AS_KS_WS | German-PhoneBook, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| German_PhoneBook_CI_AS_WS | German-PhoneBook, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| German_PhoneBook_CS_AI | German-PhoneBook, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_CS_AI_KS | German-PhoneBook, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| German_PhoneBook_CS_AI_KS_WS | German-PhoneBook, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| German_PhoneBook_CS_AI_WS | German-PhoneBook, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| German_PhoneBook_CS_AS | German-PhoneBook, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| German_PhoneBook_CS_AS_KS | German-PhoneBook, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| German_PhoneBook_CS_AS_KS_WS | German-PhoneBook, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| German_PhoneBook_CS_AS_WS | German-PhoneBook, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Hebrew_BIN | Hebrew, binary sort |
| Hebrew_CI_AS | Hebrew, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_90_BIN | Japanese-90, binary sort |
| Japanese_90_BIN2 | Japanese-90, binary code point comparison sort |
| Japanese_90_CI_AI | Japanese-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_90_CI_AI_KS | Japanese-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_90_CI_AI_KS_SC | Japanese-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_90_CI_AI_KS_SC_UTF8 | Japanese-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_90_CI_AI_KS_WS | Japanese-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_90_CI_AI_KS_WS_SC | Japanese-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_90_CI_AI_KS_WS_SC_UTF8 | Japanese-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_90_CI_AI_SC | Japanese-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_90_CI_AI_SC_UTF8 | Japanese-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_90_CI_AI_WS | Japanese-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_90_CI_AI_WS_SC | Japanese-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_90_CI_AI_WS_SC_UTF8 | Japanese-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_90_CI_AS | Japanese-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_90_CI_AS_KS | Japanese-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_90_CI_AS_KS_SC | Japanese-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_90_CI_AS_KS_SC_UTF8 | Japanese-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_90_CI_AS_KS_WS | Japanese-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_90_CI_AS_KS_WS_SC | Japanese-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_90_CI_AS_KS_WS_SC_UTF8 | Japanese-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_90_CI_AS_SC | Japanese-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_90_CI_AS_SC_UTF8 | Japanese-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_90_CI_AS_WS | Japanese-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_90_CI_AS_WS_SC | Japanese-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_90_CI_AS_WS_SC_UTF8 | Japanese-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_90_CS_AI | Japanese-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_90_CS_AI_KS | Japanese-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_90_CS_AI_KS_SC | Japanese-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_90_CS_AI_KS_SC_UTF8 | Japanese-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_90_CS_AI_KS_WS | Japanese-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_90_CS_AI_KS_WS_SC | Japanese-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_90_CS_AI_KS_WS_SC_UTF8 | Japanese-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_90_CS_AI_SC | Japanese-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_90_CS_AI_SC_UTF8 | Japanese-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_90_CS_AI_WS | Japanese-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_90_CS_AI_WS_SC | Japanese-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_90_CS_AI_WS_SC_UTF8 | Japanese-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_90_CS_AS | Japanese-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_90_CS_AS_KS | Japanese-90, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_90_CS_AS_KS_SC | Japanese-90, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_90_CS_AS_KS_SC_UTF8 | Japanese-90, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_90_CS_AS_KS_WS | Japanese-90, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_90_CS_AS_KS_WS_SC | Japanese-90, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_90_CS_AS_KS_WS_SC_UTF8 | Japanese-90, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_90_CS_AS_SC | Japanese-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_90_CS_AS_SC_UTF8 | Japanese-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_90_CS_AS_WS | Japanese-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_90_CS_AS_WS_SC | Japanese-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_90_CS_AS_WS_SC_UTF8 | Japanese-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_BIN | Japanese, binary sort |
| Japanese_BIN2 | Japanese, binary code point comparison sort |
| Japanese_Bushu_Kakusu_100_BIN | Japanese-Bushu-Kakusu-100, binary sort |
| Japanese_Bushu_Kakusu_100_BIN2 | Japanese-Bushu-Kakusu-100, binary code point comparison sort |
| Japanese_Bushu_Kakusu_100_CI_AI | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_Bushu_Kakusu_100_CI_AI_KS | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_Bushu_Kakusu_100_CI_AI_KS_SC | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CI_AI_KS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CI_AI_KS_WS | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_Bushu_Kakusu_100_CI_AI_KS_WS_SC | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CI_AI_KS_WS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CI_AI_SC | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CI_AI_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CI_AI_WS | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_Bushu_Kakusu_100_CI_AI_WS_SC | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CI_AI_WS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CI_AS | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_Bushu_Kakusu_100_CI_AS_KS | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_Bushu_Kakusu_100_CI_AS_KS_SC | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CI_AS_KS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CI_AS_KS_WS | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_Bushu_Kakusu_100_CI_AS_KS_WS_SC | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CI_AS_KS_WS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CI_AS_SC | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CI_AS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CI_AS_WS | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_Bushu_Kakusu_100_CI_AS_WS_SC | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CI_AS_WS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CS_AI | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_Bushu_Kakusu_100_CS_AI_KS | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_Bushu_Kakusu_100_CS_AI_KS_SC | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CS_AI_KS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CS_AI_KS_WS | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_Bushu_Kakusu_100_CS_AI_KS_WS_SC | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CS_AI_KS_WS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CS_AI_SC | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CS_AI_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CS_AI_WS | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_Bushu_Kakusu_100_CS_AI_WS_SC | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CS_AI_WS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CS_AS | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_Bushu_Kakusu_100_CS_AS_KS | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_Bushu_Kakusu_100_CS_AS_KS_SC | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CS_AS_KS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CS_AS_KS_WS | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_Bushu_Kakusu_100_CS_AS_KS_WS_SC | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CS_AS_KS_WS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CS_AS_SC | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CS_AS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_100_CS_AS_WS | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_Bushu_Kakusu_100_CS_AS_WS_SC | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_Bushu_Kakusu_100_CS_AS_WS_SC_UTF8 | Japanese-Bushu-Kakusu-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_Bushu_Kakusu_140_BIN | Japanese-Bushu-Kakusu-140, binary sort |
| Japanese_Bushu_Kakusu_140_BIN2 | Japanese-Bushu-Kakusu-140, binary code point comparison sort |
| Japanese_Bushu_Kakusu_140_CI_AI | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CI_AI_KS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CI_AI_KS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AI_KS_VSS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CI_AI_KS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AI_KS_WS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CI_AI_KS_WS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AI_KS_WS_VSS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CI_AI_KS_WS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AI_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AI_VSS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CI_AI_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AI_WS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CI_AI_WS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AI_WS_VSS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CI_AI_WS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CI_AS_KS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CI_AS_KS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AS_KS_VSS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CI_AS_KS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AS_KS_WS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CI_AS_KS_WS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AS_KS_WS_VSS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CI_AS_KS_WS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AS_VSS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CI_AS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AS_WS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CI_AS_WS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CI_AS_WS_VSS | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CI_AS_WS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AI | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CS_AI_KS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CS_AI_KS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AI_KS_VSS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CS_AI_KS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AI_KS_WS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CS_AI_KS_WS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AI_KS_WS_VSS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CS_AI_KS_WS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AI_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AI_VSS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CS_AI_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AI_WS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CS_AI_WS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AI_WS_VSS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CS_AI_WS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CS_AS_KS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CS_AS_KS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AS_KS_VSS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CS_AS_KS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AS_KS_WS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CS_AS_KS_WS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AS_KS_WS_VSS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CS_AS_KS_WS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AS_VSS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CS_AS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AS_WS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_Bushu_Kakusu_140_CS_AS_WS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_Bushu_Kakusu_140_CS_AS_WS_VSS | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_Bushu_Kakusu_140_CS_AS_WS_VSS_UTF8 | Japanese-Bushu-Kakusu-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_CI_AI | Japanese, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_CI_AI_KS | Japanese, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_CI_AI_KS_WS | Japanese, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_CI_AI_WS | Japanese, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_CI_AS | Japanese, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_CI_AS_KS | Japanese, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_CI_AS_KS_WS | Japanese, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_CI_AS_WS | Japanese, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_CS_AI | Japanese, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_CS_AI_KS | Japanese, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_CS_AI_KS_WS | Japanese, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_CS_AI_WS | Japanese, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_CS_AS | Japanese, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_CS_AS_KS | Japanese, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_CS_AS_KS_WS | Japanese, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_CS_AS_WS | Japanese, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_Unicode_BIN | Japanese-Unicode, binary sort |
| Japanese_Unicode_BIN2 | Japanese-Unicode, binary code point comparison sort |
| Japanese_Unicode_CI_AI | Japanese-Unicode, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_Unicode_CI_AI_KS | Japanese-Unicode, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_Unicode_CI_AI_KS_WS | Japanese-Unicode, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_Unicode_CI_AI_WS | Japanese-Unicode, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_Unicode_CI_AS | Japanese-Unicode, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_Unicode_CI_AS_KS | Japanese-Unicode, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_Unicode_CI_AS_KS_WS | Japanese-Unicode, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_Unicode_CI_AS_WS | Japanese-Unicode, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_Unicode_CS_AI | Japanese-Unicode, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_Unicode_CS_AI_KS | Japanese-Unicode, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_Unicode_CS_AI_KS_WS | Japanese-Unicode, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_Unicode_CS_AI_WS | Japanese-Unicode, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_Unicode_CS_AS | Japanese-Unicode, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_Unicode_CS_AS_KS | Japanese-Unicode, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_Unicode_CS_AS_KS_WS | Japanese-Unicode, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_Unicode_CS_AS_WS | Japanese-Unicode, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_XJIS_100_BIN | Japanese-XJIS-100, binary sort |
| Japanese_XJIS_100_BIN2 | Japanese-XJIS-100, binary code point comparison sort |
| Japanese_XJIS_100_CI_AI | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_XJIS_100_CI_AI_KS | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_XJIS_100_CI_AI_KS_SC | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_XJIS_100_CI_AI_KS_SC_UTF8 | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CI_AI_KS_WS | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_XJIS_100_CI_AI_KS_WS_SC | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_XJIS_100_CI_AI_KS_WS_SC_UTF8 | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CI_AI_SC | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_XJIS_100_CI_AI_SC_UTF8 | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CI_AI_WS | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_XJIS_100_CI_AI_WS_SC | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_XJIS_100_CI_AI_WS_SC_UTF8 | Japanese-XJIS-100, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CI_AS | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_XJIS_100_CI_AS_KS | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_XJIS_100_CI_AS_KS_SC | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_XJIS_100_CI_AS_KS_SC_UTF8 | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CI_AS_KS_WS | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_XJIS_100_CI_AS_KS_WS_SC | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_XJIS_100_CI_AS_KS_WS_SC_UTF8 | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CI_AS_SC | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_XJIS_100_CI_AS_SC_UTF8 | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CI_AS_WS | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_XJIS_100_CI_AS_WS_SC | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_XJIS_100_CI_AS_WS_SC_UTF8 | Japanese-XJIS-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CS_AI | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Japanese_XJIS_100_CS_AI_KS | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive |
| Japanese_XJIS_100_CS_AI_KS_SC | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_XJIS_100_CS_AI_KS_SC_UTF8 | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CS_AI_KS_WS | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive |
| Japanese_XJIS_100_CS_AI_KS_WS_SC | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_XJIS_100_CS_AI_KS_WS_SC_UTF8 | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CS_AI_SC | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_XJIS_100_CS_AI_SC_UTF8 | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CS_AI_WS | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive |
| Japanese_XJIS_100_CS_AI_WS_SC | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_XJIS_100_CS_AI_WS_SC_UTF8 | Japanese-XJIS-100, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CS_AS | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Japanese_XJIS_100_CS_AS_KS | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Japanese_XJIS_100_CS_AS_KS_SC | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters |
| Japanese_XJIS_100_CS_AS_KS_SC_UTF8 | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CS_AS_KS_WS | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive |
| Japanese_XJIS_100_CS_AS_KS_WS_SC | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters |
| Japanese_XJIS_100_CS_AS_KS_WS_SC_UTF8 | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CS_AS_SC | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters |
| Japanese_XJIS_100_CS_AS_SC_UTF8 | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Japanese_XJIS_100_CS_AS_WS | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive |
| Japanese_XJIS_100_CS_AS_WS_SC | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters |
| Japanese_XJIS_100_CS_AS_WS_SC_UTF8 | Japanese-XJIS-100, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, UTF8 |
| Japanese_XJIS_140_BIN | Japanese-XJIS-140, binary sort |
| Japanese_XJIS_140_BIN2 | Japanese-XJIS-140, binary code point comparison sort |
| Japanese_XJIS_140_CI_AI | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CI_AI_KS | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CI_AI_KS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CI_AI_KS_VSS | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CI_AI_KS_VSS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CI_AI_KS_WS | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CI_AI_KS_WS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CI_AI_KS_WS_VSS | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CI_AI_KS_WS_VSS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CI_AI_UTF8 | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CI_AI_VSS | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CI_AI_VSS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CI_AI_WS | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CI_AI_WS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CI_AI_WS_VSS | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CI_AI_WS_VSS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CI_AS | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CI_AS_KS | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CI_AS_KS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CI_AS_KS_VSS | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CI_AS_KS_VSS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CI_AS_KS_WS | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CI_AS_KS_WS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CI_AS_KS_WS_VSS | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CI_AS_KS_WS_VSS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CI_AS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CI_AS_VSS | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CI_AS_VSS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CI_AS_WS | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CI_AS_WS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CI_AS_WS_VSS | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CI_AS_WS_VSS_UTF8 | Japanese-XJIS-140, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CS_AI | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CS_AI_KS | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CS_AI_KS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CS_AI_KS_VSS | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CS_AI_KS_VSS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CS_AI_KS_WS | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CS_AI_KS_WS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CS_AI_KS_WS_VSS | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CS_AI_KS_WS_VSS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CS_AI_UTF8 | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CS_AI_VSS | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CS_AI_VSS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CS_AI_WS | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CS_AI_WS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CS_AI_WS_VSS | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CS_AI_WS_VSS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CS_AS | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CS_AS_KS | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CS_AS_KS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CS_AS_KS_VSS | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CS_AS_KS_VSS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CS_AS_KS_WS | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CS_AS_KS_WS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CS_AS_KS_WS_VSS | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CS_AS_KS_WS_VSS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CS_AS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CS_AS_VSS | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CS_AS_VSS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, variation selector sensitive, UTF8 |
| Japanese_XJIS_140_CS_AS_WS | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive |
| Japanese_XJIS_140_CS_AS_WS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector insensitive, UTF8 |
| Japanese_XJIS_140_CS_AS_WS_VSS | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive |
| Japanese_XJIS_140_CS_AS_WS_VSS_UTF8 | Japanese-XJIS-140, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive, supplementary characters, variation selector sensitive, UTF8 |
| Korean_Wansung_CI_AS | Korean-Wansung, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Latin1_General_100_BIN | Latin1-General-100, binary sort |
| Latin1_General_100_BIN2 | Latin1-General-100, binary code point comparison sort |
| Latin1_General_100_BIN2_UTF8 | Latin1-General-100, binary code point comparison sort, UTF8 |
| Latin1_General_100_CI_AS | Latin1-General-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Latin1_General_100_CI_AS_SC_UTF8 | Latin1-General-100, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive, supplementary characters, UTF8 |
| Latin1_General_BIN | Latin1-General, binary sort |
| Latin1_General_BIN2 | Latin1-General, binary code point comparison sort |
| Latin1_General_CI_AI | Latin1-General, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive |
| Latin1_General_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Latin1_General_CI_AS_KS | Latin1-General, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive |
| Latin1_General_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| Modern_Spanish_CI_AS | Modern-Spanish, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
| SQL_1xCompat_CP850_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 49 on Code Page 850 for non-Unicode Data |
| SQL_Latin1_General_CP1_CI_AI | Latin1-General, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 54 on Code Page 1252 for non-Unicode Data |
| SQL_Latin1_General_CP1_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data |
| SQL_Latin1_General_CP1_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 51 on Code Page 1252 for non-Unicode Data |
| SQL_Latin1_General_CP1250_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 82 on Code Page 1250 for non-Unicode Data |
| SQL_Latin1_General_CP1250_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 81 on Code Page 1250 for non-Unicode Data |
| SQL_Latin1_General_CP1251_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 106 on Code Page 1251 for non-Unicode Data |
| SQL_Latin1_General_CP1251_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 105 on Code Page 1251 for non-Unicode Data |
| SQL_Latin1_General_CP1253_CI_AI | Latin1-General, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 124 on Code Page 1253 for non-Unicode Data |
| SQL_Latin1_General_CP1253_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 114 on Code Page 1253 for non-Unicode Data |
| SQL_Latin1_General_CP1253_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 113 on Code Page 1253 for non-Unicode Data |
| SQL_Latin1_General_CP1254_CI_AS | Turkish, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 130 on Code Page 1254 for non-Unicode Data |
| SQL_Latin1_General_CP1254_CS_AS | Turkish, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 129 on Code Page 1254 for non-Unicode Data |
| SQL_Latin1_General_CP1255_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 138 on Code Page 1255 for non-Unicode Data |
| SQL_Latin1_General_CP1255_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 137 on Code Page 1255 for non-Unicode Data |
| SQL_Latin1_General_CP1256_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 146 on Code Page 1256 for non-Unicode Data |
| SQL_Latin1_General_CP1256_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 145 on Code Page 1256 for non-Unicode Data |
| SQL_Latin1_General_CP1257_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 154 on Code Page 1257 for non-Unicode Data |
| SQL_Latin1_General_CP1257_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 153 on Code Page 1257 for non-Unicode Data |
| SQL_Latin1_General_CP437_BIN | Latin1-General, binary sort for Unicode Data, SQL Server Sort Order 30 on Code Page 437 for non-Unicode Data |
| SQL_Latin1_General_CP437_BIN2 | Latin1-General, binary code point comparison sort for Unicode Data, SQL Server Sort Order 30 on Code Page 437 for non-Unicode Data |
| SQL_Latin1_General_CP437_CI_AI | Latin1-General, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 34 on Code Page 437 for non-Unicode Data |
| SQL_Latin1_General_CP437_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 32 on Code Page 437 for non-Unicode Data |
| SQL_Latin1_General_CP437_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 31 on Code Page 437 for non-Unicode Data |
| SQL_Latin1_General_CP850_BIN | Latin1-General, binary sort for Unicode Data, SQL Server Sort Order 40 on Code Page 850 for non-Unicode Data |
| SQL_Latin1_General_CP850_BIN2 | Latin1-General, binary code point comparison sort for Unicode Data, SQL Server Sort Order 40 on Code Page 850 for non-Unicode Data |
| SQL_Latin1_General_CP850_CI_AI | Latin1-General, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 44 on Code Page 850 for non-Unicode Data |
| SQL_Latin1_General_CP850_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 42 on Code Page 850 for non-Unicode Data |
| SQL_Latin1_General_CP850_CS_AS | Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 41 on Code Page 850 for non-Unicode Data |
| SQL_Latin1_General_Pref_CP1_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 53 on Code Page 1252 for non-Unicode Data |
| SQL_Latin1_General_Pref_CP437_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 33 on Code Page 437 for non-Unicode Data |
| SQL_Latin1_General_Pref_CP850_CI_AS | Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 43 on Code Page 850 for non-Unicode Data |
| Thai_CI_AS | Thai, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive |
Local time zone for RDS Custom for SQL Server DB instances
The time zone of an RDS Custom for SQL Server DB instance is set by default. The current default is Coordinated Universal Time (UTC). You can set the time zone of your DB instance to a local time zone instead, to match the time zone of your applications.
You set the time zone when you first create your DB instance. You can create your DB instance by using the AWS Management Console, the Amazon RDS API CreateDBInstance action, or the AWS CLI create-db-instance command.
If your DB instance is part of a Multi-AZ deployment, then when you fail over, your time zone remains the local time zone that you set.
When you request a point-in-time restore, you specify the time to restore to. The time is shown in your local time zone. For more information, see Restoring a DB instance to a specified time.
The following are limitations to setting the local time zone on your DB instance:
-
You can configure the time zone for a DB instance during instance creation, but you can't modify the time zone of an existing RDS Custom for SQL Server DB instance.
-
If the time zone is modified for an existing RDS Custom for SQL Server DB instance, RDS Custom changes the DB instance status to
unsupported-configuration, and sends event notifications. -
You can't restore a snapshot from a DB instance in one time zone to a DB instance in a different time zone.
-
We strongly recommend that you don't restore a backup file from one time zone to a different time zone. If you restore a backup file from one time zone to a different time zone, you must audit your queries and applications for the effects of the time zone change. For more information, see Importing and exporting SQL Server databases using native backup and restore.
Supported time zones
You can set your local time zone to one of the values listed in the following table.
Time zones supported for RDS Custom for SQL Server | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Time zone |
Standard time offset |
Description |
Notes |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan Standard Time |
(UTC+04:30) |
Kabul |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Alaskan Standard Time |
(UTC–09:00) |
Alaska |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Aleutian Standard Time | (UTC–10:00) | Aleutian Islands | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Altai Standard Time | (UTC+07:00) | Barnaul, Gorno-Altaysk | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Arab Standard Time | (UTC+03:00) | Kuwait, Riyadh | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Arabian Standard Time |
(UTC+04:00) |
Abu Dhabi, Muscat |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Arabic Standard Time | (UTC+03:00) | Baghdad | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Argentina Standard Time | (UTC–03:00) | City of Buenos Aires | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Astrakhan Standard Time | (UTC+04:00) | Astrakhan, Ulyanovsk | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Atlantic Standard Time |
(UTC–04:00) |
Atlantic Time (Canada) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AUS Central Standard Time |
(UTC+09:30) |
Darwin |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Aus Central W. Standard Time | (UTC+08:45) | Eucla | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
AUS Eastern Standard Time |
(UTC+10:00) |
Canberra, Melbourne, Sydney |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Azerbaijan Standard Time | (UTC+04:00) | Baku | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Azores Standard Time | (UTC–01:00) | Azores | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Bahia Standard Time | (UTC–03:00) | Salvador | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Bangladesh Standard Time | (UTC+06:00) | Dhaka | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Belarus Standard Time |
(UTC+03:00) |
Minsk |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Bougainville Standard Time | (UTC+11:00) | Bougainville Island | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Canada Central Standard Time |
(UTC–06:00) |
Saskatchewan |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cape Verde Standard Time |
(UTC–01:00) |
Cabo Verde Is. |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Caucasus Standard Time | (UTC+04:00) | Yerevan | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cen. Australia Standard Time |
(UTC+09:30) |
Adelaide |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Central America Standard Time |
(UTC–06:00) |
Central America |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Central Asia Standard Time |
(UTC+06:00) |
Astana |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Central Brazilian Standard Time |
(UTC–04:00) |
Cuiaba |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Central Europe Standard Time |
(UTC+01:00) |
Belgrade, Bratislava, Budapest, Ljubljana, Prague |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Central European Standard Time |
(UTC+01:00) |
Sarajevo, Skopje, Warsaw, Zagreb |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Central Pacific Standard Time |
(UTC+11:00) |
Solomon Islands, New Caledonia |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Central Standard Time |
(UTC–06:00) |
Central Time (US and Canada) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Central Standard Time (Mexico) |
(UTC–06:00) |
Guadalajara, Mexico City, Monterrey |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Chatham Islands Standard Time | (UTC+12:45) | Chatham Islands | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
China Standard Time |
(UTC+08:00) |
Beijing, Chongqing, Hong Kong, Urumqi |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cuba Standard Time | (UTC–05:00) | Havana | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Dateline Standard Time | (UTC–12:00) | International Date Line West | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
E. Africa Standard Time |
(UTC+03:00) |
Nairobi |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
E. Australia Standard Time |
(UTC+10:00) |
Brisbane |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
E. Europe Standard Time |
(UTC+02:00) |
Chisinau |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
E. South America Standard Time |
(UTC–03:00) |
Brasilia |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Easter Island Standard Time | (UTC–06:00) | Easter Island | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Eastern Standard Time |
(UTC–05:00) |
Eastern Time (US and Canada) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Eastern Standard Time (Mexico) | (UTC–05:00) | Chetumal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Egypt Standard Time | (UTC+02:00) | Cairo | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Ekaterinburg Standard Time | (UTC+05:00) | Ekaterinburg | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Fiji Standard Time | (UTC+12:00) | Fiji | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
FLE Standard Time | (UTC+02:00) | Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Georgian Standard Time |
(UTC+04:00) |
Tbilisi |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GMT Standard Time |
(UTC) |
Dublin, Edinburgh, Lisbon, London |
This time zone isn't the same as Greenwich Mean Time. This time zone does observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Greenland Standard Time |
(UTC–03:00) |
Greenland |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Greenwich Standard Time |
(UTC) |
Monrovia, Reykjavik |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GTB Standard Time |
(UTC+02:00) |
Athens, Bucharest |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Haiti Standard Time | (UTC–05:00) | Haiti | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Hawaiian Standard Time |
(UTC–10:00) |
Hawaii |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
India Standard Time |
(UTC+05:30) |
Chennai, Kolkata, Mumbai, New Delhi |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Iran Standard Time | (UTC+03:30) | Tehran | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Israel Standard Time | (UTC+02:00) | Jerusalem | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Jordan Standard Time |
(UTC+02:00) |
Amman |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Kaliningrad Standard Time | (UTC+02:00) | Kaliningrad | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Kamchatka Standard Time | (UTC+12:00) | Petropavlovsk-Kamchatsky – Old | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Korea Standard Time |
(UTC+09:00) |
Seoul |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Libya Standard Time | (UTC+02:00) | Tripoli | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line Islands Standard Time | (UTC+14:00) | Kiritimati Island | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Lord Howe Standard Time | (UTC+10:30) | Lord Howe Island | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Magadan Standard Time | (UTC+11:00) | Magadan | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Magallanes Standard Time | (UTC–03:00) | Punta Arenas | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Marquesas Standard Time | (UTC–09:30) | Marquesas Islands | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mauritius Standard Time | (UTC+04:00) | Port Louis | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Middle East Standard Time |
(UTC+02:00) |
Beirut |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Montevideo Standard Time | (UTC–03:00) | Montevideo | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Morocco Standard Time | (UTC+01:00) | Casablanca | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mountain Standard Time |
(UTC–07:00) |
Mountain Time (US and Canada) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mountain Standard Time (Mexico) |
(UTC–07:00) |
Chihuahua, La Paz, Mazatlan |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Myanmar Standard Time | (UTC+06:30) | Yangon (Rangoon) | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
N. Central Asia Standard Time | (UTC+07:00) | Novosibirsk | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Namibia Standard Time | (UTC+02:00) | Windhoek | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Nepal Standard Time | (UTC+05:45) | Kathmandu | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
New Zealand Standard Time |
(UTC+12:00) |
Auckland, Wellington |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Newfoundland Standard Time |
(UTC–03:30) |
Newfoundland |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Norfolk Standard Time | (UTC+11:00) | Norfolk Island | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
North Asia East Standard Time | (UTC+08:00) | Irkutsk | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
North Asia Standard Time | (UTC+07:00) | Krasnoyarsk | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
North Korea Standard Time | (UTC+09:00) | Pyongyang | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Omsk Standard Time | (UTC+06:00) | Omsk | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Pacific SA Standard Time |
(UTC–03:00) |
Santiago |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Pacific Standard Time |
(UTC–08:00) |
Pacific Time (US and Canada) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Pacific Standard Time (Mexico) |
(UTC–08:00) |
Baja California |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Pakistan Standard Time | (UTC+05:00) | Islamabad, Karachi | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Paraguay Standard Time | (UTC–04:00) | Asuncion | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Romance Standard Time | (UTC+01:00) | Brussels, Copenhagen, Madrid, Paris | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Russia Time Zone 10 | (UTC+11:00) | Chokurdakh | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Russia Time Zone 11 | (UTC+12:00) | Anadyr, Petropavlovsk-Kamchatsky | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Russia Time Zone 3 | (UTC+04:00) | Izhevsk, Samara | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Russian Standard Time |
(UTC+03:00) |
Moscow, St. Petersburg, Volgograd |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SA Eastern Standard Time | (UTC–03:00) | Cayenne, Fortaleza | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SA Pacific Standard Time |
(UTC–05:00) |
Bogota, Lima, Quito, Rio Branco |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SA Western Standard Time | (UTC–04:00) | Georgetown, La Paz, Manaus, San Juan | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Saint Pierre Standard Time | (UTC–03:00) | Saint Pierre and Miquelon | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sakhalin Standard Time | (UTC+11:00) | Sakhalin | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Samoa Standard Time | (UTC+13:00) | Samoa | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sao Tome Standard Time | (UTC+01:00) | Sao Tome | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Saratov Standard Time | (UTC+04:00) | Saratov | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SE Asia Standard Time |
(UTC+07:00) |
Bangkok, Hanoi, Jakarta |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Singapore Standard Time |
(UTC+08:00) |
Kuala Lumpur, Singapore |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
South Africa Standard Time | (UTC+02:00) | Harare, Pretoria | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sri Lanka Standard Time | (UTC+05:30) | Sri Jayawardenepura | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sudan Standard Time | (UTC+02:00) | Khartoum | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Syria Standard Time | (UTC+02:00) | Damascus | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Taipei Standard Time | (UTC+08:00) | Taipei | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tasmania Standard Time | (UTC+10:00) | Hobart | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tocantins Standard Time | (UTC–03:00) | Araguaina | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tokyo Standard Time |
(UTC+09:00) |
Osaka, Sapporo, Tokyo |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tomsk Standard Time | (UTC+07:00) | Tomsk | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tonga Standard Time | (UTC+13:00) | Nuku'alofa | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Transbaikal Standard Time | (UTC+09:00) | Chita | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Turkey Standard Time |
(UTC+03:00) |
Istanbul |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Turks And Caicos Standard Time | (UTC–05:00) | Turks and Caicos | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Ulaanbaatar Standard Time | (UTC+08:00) | Ulaanbaatar | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
US Eastern Standard Time |
(UTC–05:00) |
Indiana (East) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
US Mountain Standard Time |
(UTC–07:00) |
Arizona |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UTC |
UTC |
Coordinated Universal Time |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UTC–02 |
(UTC–02:00) |
Coordinated Universal Time–02 |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UTC–08 |
(UTC–08:00) |
Coordinated Universal Time–08 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UTC–09 |
(UTC–09:00) |
Coordinated Universal Time–09 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UTC–11 |
(UTC–11:00) |
Coordinated Universal Time–11 |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UTC+12 |
(UTC+12:00) |
Coordinated Universal Time+12 |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UTC+13 | (UTC+13:00) | Coordinated Universal Time+13 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Venezuela Standard Time | (UTC–04:00) | Caracas | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Vladivostok Standard Time | (UTC+10:00) | Vladivostok | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Volgograd Standard Time | (UTC+04:00) | Volgograd | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
W. Australia Standard Time |
(UTC+08:00) |
Perth |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
W. Central Africa Standard Time |
(UTC+01:00) |
West Central Africa |
This time zone doesn't observe daylight saving time. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
W. Europe Standard Time |
(UTC+01:00) |
Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
W. Mongolia Standard Time | (UTC+07:00) | Hovd | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
West Asia Standard Time | (UTC+05:00) | Ashgabat, Tashkent | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
West Bank Standard Time | (UTC+02:00) | Gaza, Hebron | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
West Pacific Standard Time | (UTC+10:00) | Guam, Port Moresby | This time zone doesn't observe daylight saving time. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Yakutsk Standard Time | (UTC+09:00) | Yakutsk | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Using a Service Master Key with RDS Custom for SQL Server
RDS Custom for SQL Server supports using a Service Master Key (SMK). RDS Custom retains the same SMK throughout the lifespan of your RDS Custom for SQL Server DB instance. By retaining the same SMK, your DB instance can use objects that are encrypted with the SMK, such as linked server passwords and credentials. If you use a Multi-AZ deployment, RDS Custom also synchronizes and maintains the SMK between primary and secondary DB instances.
Topics
Region and version availability
Using an SMK is supported in all Regions where RDS Custom for SQL Server is available, for all SQL Server versions available on RDS Custom. For more information on version and Region availability of Amazon RDS with RDS Custom for SQL Server, see RDS Custom for SQL Server.
Supported features
When using a SMK with RDS Custom for SQL Server, the following features are supported:
Transparent Data Encryption (TDE)
Column-level encryption
Database Mail
Linked Servers
SQL Server Integration Services (SSIS)
Using TDE
An SMK enables the ability to configure Transparent Data Encryption (TDE), which encrypts data before it is written to storage, and automatically decrypts data when the data is read from storage. Unlike RDS for SQL Server, configuring TDE on an RDS Custom for SQL Server DB instance doesn't require using option groups. Instead, once you've created a certificate and database encryption key, you can run the following command to turn on TDE at the database level:
ALTER DATABASE [myDatabase] SET ENCRYPTION ON;
For more information on using TDE with RDS for SQL Server, see Support for Transparent Data Encryption in SQL Server.
For detailed information on TDE in Microsoft SQL Server, see
Transparent data encryption
Configuring features
For detailed steps on configuring features that use a SMK with RDS Custom for SQL Server, you can use the following posts in the Amazon RDS database blog:
Requirements and limitations
When using an SMK with an RDS Custom for SQL Server DB instance, keep in mind the following requirements and limitations:
If you re-generate the SMK on your DB instance, you should immediately perform a manual DB snapshot. We recommend avoiding re-generating the SMK if possible.
You must maintain backups of the server certificates and database master key passwords. If you don't maintain backups of these, it may result in data loss.
If you configure SSIS, you should use an SSM document to join the RDS Custom for SQL Server DB instance to the domain in case of a scale compute or host replacement.
When TDE or column-encryption is enabled, database backups are automatically encrypted. When you perform a snapshot restore or point in time recovery, the SMK from the source DB instance will be restored to decrypt data for the restore, and a new SMK will be generated to re-encrypt data on the restored instance.
For more information on Service Master Keys in Microsoft SQL Server, see
SQL Server and Database Encryption Keys
