User Tools
niota-docs:niota_sample_values
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_sample_values [2021/11/14 11:15] admin |
niota-docs:niota_sample_values [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| * ''iso-8859-2'' - Windows typical western character set | * ''iso-8859-2'' - Windows typical western character set | ||
| * ''UTF-8'' | * ''UTF-8'' | ||
| + | * ''SQLSRV_ENC_CHAR'' -- system variable in case of native MS SQL server connection when DB is not UTF-8 | ||
| === source date format === | === source date format === | ||
| Line 21: | Line 22: | ||
| Y-m-d H:i:s.f | Y-m-d H:i:s.f | ||
| </code> | </code> | ||
| - | |||
| === display date format === | === display date format === | ||
| - | Formatstring with separator character that describes how date variables are stored in the database. | + | Formatstring with separator character that describes how date variables are displayed in niota. |
| Sample value(s): | Sample value(s): | ||
| <code> | <code> | ||
| Y-m-d | Y-m-d | ||
| + | </code> | ||
| + | |||
| + | === display datetime format === | ||
| + | Formatstring with separator character that describes how datetime variables displayed in niota. | ||
| + | |||
| + | Sample value(s): | ||
| + | <code> | ||
| + | Y-m-d H:i:s | ||
| </code> | </code> | ||
niota-docs/niota_sample_values.1636884959.txt.gz · Last modified: 2025/07/17 14:11 (external edit)