DBGate Sample 13 - Data Types

Light Theme Dark Theme

This example allows you to test supported data types across various data providers.
Behavior may vary; for instance, ODBC drivers might not support datetime2 or spatial data types.

The datatypes table includes fields for the tested data types. You can access the table data through any provider.
The usp_datatypes procedure retrieves data as-is. Note that ODBC and OLEDB providers may not support some types.
The usp_odbc_datatypes procedure selects data with necessary casts to ensure compatibility with ODBC and OLEDB.
You can view the source code for the tables and procedures using the provided links.

OLEDB providers are supported in the .NET Framework but not in .NET Core.

You can open data in the editor. Select your language below and click the links to view JSON data.

en-US en-CA en-GB en-AU en-IN be-BY da-DK de-DE de-AT de-CH es-ES es-US fi-FI fr-FR fr-CA fr-CH hi-IN it-IT ja-JP ko-KO no-NO pt-PT pt-BR ru-RU sv-SV uk-UA zh-CN zh-TW

SQL Server

System.Data.SqlClient	datatypes	usp_datatypes	usp_odbc_datatypes	$metadata
Microsoft.Data.SqlClient	datatypes	usp_datatypes	usp_odbc_datatypes	$metadata
ODBC Driver 17	datatypes	usp_datatypes	usp_odbc_datatypes	$metadata
Source code	datatypes	usp_datatypes	usp_odbc_datatypes

PostgreSQL

Npgsql	datatypes	usp_datatypes	usp_odbc_datatypes	$metadata
ODBC Driver	datatypes	usp_datatypes	usp_odbc_datatypes	$metadata
Source code	datatypes	usp_datatypes	usp_odbc_datatypes

MySQL

MySqlConnector	datatypes	usp_datatypes	usp_odbc_datatypes	$metadata
MySql.Data.MySqlClient	datatypes	usp_datatypes	usp_odbc_datatypes	$metadata
ODBC Driver	datatypes	usp_datatypes	usp_odbc_datatypes	$metadata
Source code	datatypes	usp_datatypes	usp_odbc_datatypes

Conclusion

DBGate supports nearly all data types via ODBC, OLEDB, and .NET data providers.

You can download samples for any supported database platform using the SaveToDB SDK.