Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add the 'BindInvariantDecimal' connection flag, enabled by default, which forces Decimal parameters to be converted to strings using the invariant culture. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
da44957e767258c02c5417b440a6ba00 |
| User & Date: | mistachkin 2017-10-17 20:01:29.282 |
Context
|
2017-10-18
| ||
| 07:11 | Update comments in the session test file. check-in: 7957c296b8 user: mistachkin tags: trunk | |
|
2017-10-17
| ||
| 20:01 | Add the 'BindInvariantDecimal' connection flag, enabled by default, which forces Decimal parameters to be converted to strings using the invariant culture. check-in: da44957e76 user: mistachkin tags: trunk | |
| 19:59 | Update SQLite core library to the latest 'branch-3.21' code. check-in: 1f07d53a90 user: mistachkin tags: trunk | |
Changes
Changes to System.Data.SQLite/SQLiteBase.cs.
| ︙ | ︙ | |||
1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 |
/// <summary>
/// When returning column values, always return <see cref="Decimal" />
/// values as though they were plain text (i.e. not <see cref="Double" />,
/// which is the legacy behavior).
/// </summary>
GetDecimalAsText = 0x20000000000,
/// <summary>
/// When binding parameter values or returning column values, always
/// treat them as though they were plain text (i.e. no numeric,
/// date/time, or other conversions should be attempted).
/// </summary>
BindAndGetAllAsText = BindAllAsText | GetAllAsText,
| > > > > > > | 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 |
/// <summary>
/// When returning column values, always return <see cref="Decimal" />
/// values as though they were plain text (i.e. not <see cref="Double" />,
/// which is the legacy behavior).
/// </summary>
GetDecimalAsText = 0x20000000000,
/// <summary>
/// When binding <see cref="Decimal" /> parameter values, always use
/// the invariant culture when converting their values to strings.
/// </summary>
BindInvariantDecimal = 0x40000000000,
/// <summary>
/// When binding parameter values or returning column values, always
/// treat them as though they were plain text (i.e. no numeric,
/// date/time, or other conversions should be attempted).
/// </summary>
BindAndGetAllAsText = BindAllAsText | GetAllAsText,
|
| ︙ | ︙ | |||
1312 1313 1314 1315 1316 1317 1318 |
LogModuleException,
#else
LogAll = LogPrepare | LogPreBind | LogBind |
LogCallbackException | LogBackup,
#endif
/// <summary>
| | | | > > > > > | 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 |
LogModuleException,
#else
LogAll = LogPrepare | LogPreBind | LogBind |
LogCallbackException | LogBackup,
#endif
/// <summary>
/// The default logging related flags for new connections.
/// </summary>
#if INTEROP_VIRTUAL_TABLE
LogDefault = LogCallbackException | LogModuleException,
#else
LogDefault = LogCallbackException,
#endif
/// <summary>
/// The default extra flags for new connections.
/// </summary>
Default = LogDefault | BindInvariantDecimal,
/// <summary>
/// The default extra flags for new connections with all logging enabled.
/// </summary>
DefaultAndLogAll = Default | LogAll
}
/// <summary>
|
| ︙ | ︙ |
Changes to System.Data.SQLite/SQLiteStatement.cs.
| ︙ | ︙ | |||
436 437 438 439 440 441 442 443 444 445 446 447 |
_sql.Bind_Text(this, _flags, index, invariantText ?
SQLiteConvert.ToStringWithProvider(obj, invariantCultureInfo) :
SQLiteConvert.ToStringWithProvider(obj, cultureInfo));
}
return;
}
if ((_flags & SQLiteConnectionFlags.BindDecimalAsText) == SQLiteConnectionFlags.BindDecimalAsText)
{
if (obj is Decimal)
{
| > > > | | 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 |
_sql.Bind_Text(this, _flags, index, invariantText ?
SQLiteConvert.ToStringWithProvider(obj, invariantCultureInfo) :
SQLiteConvert.ToStringWithProvider(obj, cultureInfo));
}
return;
}
bool invariantDecimal = ((_flags & SQLiteConnectionFlags.BindInvariantDecimal)
== SQLiteConnectionFlags.BindInvariantDecimal);
if ((_flags & SQLiteConnectionFlags.BindDecimalAsText) == SQLiteConnectionFlags.BindDecimalAsText)
{
if (obj is Decimal)
{
_sql.Bind_Text(this, _flags, index, invariantText || invariantDecimal ?
SQLiteConvert.ToStringWithProvider(obj, invariantCultureInfo) :
SQLiteConvert.ToStringWithProvider(obj, cultureInfo));
return;
}
}
|
| ︙ | ︙ | |||
491 492 493 494 495 496 497 |
break;
case DbType.UInt64:
_sql.Bind_UInt64(this, _flags, index, Convert.ToUInt64(obj, cultureInfo));
break;
case DbType.Single:
case DbType.Double:
case DbType.Currency:
| < | | | | 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 |
break;
case DbType.UInt64:
_sql.Bind_UInt64(this, _flags, index, Convert.ToUInt64(obj, cultureInfo));
break;
case DbType.Single:
case DbType.Double:
case DbType.Currency:
_sql.Bind_Double(this, _flags, index, Convert.ToDouble(obj, cultureInfo));
break;
case DbType.Binary:
_sql.Bind_Blob(this, _flags, index, (byte[])obj);
break;
case DbType.Guid:
if (_command.Connection._binaryGuid == true)
{
_sql.Bind_Blob(this, _flags, index, ((Guid)obj).ToByteArray());
}
else
{
_sql.Bind_Text(this, _flags, index, invariantText ?
SQLiteConvert.ToStringWithProvider(obj, invariantCultureInfo) :
SQLiteConvert.ToStringWithProvider(obj, cultureInfo));
}
break;
case DbType.Decimal: // Dont store decimal as double ... loses precision
_sql.Bind_Text(this, _flags, index, invariantText || invariantDecimal ?
SQLiteConvert.ToStringWithProvider(Convert.ToDecimal(obj, cultureInfo), invariantCultureInfo) :
SQLiteConvert.ToStringWithProvider(Convert.ToDecimal(obj, cultureInfo), cultureInfo));
break;
default:
_sql.Bind_Text(this, _flags, index, invariantText ?
SQLiteConvert.ToStringWithProvider(obj, invariantCultureInfo) :
SQLiteConvert.ToStringWithProvider(obj, cultureInfo));
break;
}
|
| ︙ | ︙ |