synchronizer_support_for_sql_server_2008_data_types.htm
| Navigation: SQL Drivers > MSSQL Accelerator >====== Synchronizer Support for SQL Server Data Types ====== |    |
MS SQL data types and their Clarion representations:
| SQL Server Data Type | Clarion equivalent | |
| DATE | DATE | |
| GEOMETRY | BLOB | |
| GEOGRAPHY | BLOB | |
| HIERARCHYID | CSTRING(4001),NAME(field | SELECTNAME=field.ToString()) |
| DATETIME2(n) | Standard STRING/GROUP/DATE/TIME date/time stamp structure | |
| TIME(0) | TIME | |
| TIME(n) | STRING(n+9)GROUP,OVER(string)PICTURE(@T4)PICTURE(@P.P)PICTURE(@N0n)END | |
| DATETIMEOFFSET(0) | STRING(26)GROUP,OVER(string)PICTURE(@D10-)PICTURE(@P P)PICTURE(@T4)STRING(2)PICTURE(@T1)END | |
| DATETIMEOFFSET(n) | STRING(26)GROUP,OVER(string)PICTURE(@D10-)PICTURE(@P P)PICTURE(@T4)PICTURE(@P.P)PICTURE(@N0n)STRING(2)PICTURE(@T1)ENDNOTE: When using DATETIMEOFFSET the program must make certain that the STRING(2) field contains ' +' or ' -' only. |
synchronizer_support_for_sql_server_2008_data_types.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1