Timezone aware datatypes - PostgreSQL & MySQL, potential inconsistencies with UTC? 2
postgresql mysql dbfiddle
Vérace Vérace
How do I get this fiddle to insert UTF-8 characters?
Hannah Vernon Hannah Vernon
5 `utf8` in MySQL is a synonym for `utf8mb3`, which encodes to a **maximum of three bytes**. You cannot encode the 😲 character in three bytes of UTF8.
Paul White
Feature request - support for Firebird >= 4 1
firebird
Vérace Vérace
2 > it would be good to have Firebird >= 4
Jack Douglas
Feature request for db<>fiddle! Timezone support for MySQL (not just offset support). 1
mysql
Vérace Vérace
3 Thanks for pointing this out and including a link for how to resolve the issue. This is now fixed for all active versions of MySQL and MariaDB.
Jack Douglas
Passwords for Databases 18 15
Blog
faq
John K N John K N
Deadlock between online index rebuild and auto update stats
sql-server-2017
Anonymous 2148 Anonymous 2148
TempDB Version Store cleanup
sql-server-2005
Cougar9000 Cougar9000
8 >*Is the oldest transaction database specific or will SQL Server keep all versions, regardless of the database, if there is an older transaction still active, period?*
Paul White
4 The version store can only clear versions based on the oldest active transaction within the entire *instance*, to support the use of transaction-level snapshot isolation across multiple databases simultaneously. That simply wouldn't work if "old" versions within one database were cleared out in the middle of another database's snapshot transaction.
Jon Seigel
Is it possible to use OPENROWSET to import fixed width UTF8 encoded files?
sql-server azure-sql-database
Martin Smith Martin Smith
8 One workaround is to just change the format file to bring the whole line in, in bulk, and do the substring-ing in TSQL
Martin Smith
6 > from which I conclude the `LENGTH` is counting bytes rather than characters.
Paul White
group on words in a varchar attribute
postgresql
Anonymous 2230 Anonymous 2230
6 If the words in your case are always going to be separated by the same character (like a space, for instance), you could try using the [`split_part()`](https://www.postgresql.org/docs/current/functions-string.html#id-1.5.8.10.7.2.2.31.1.1.1) function instead of regular expressions.
Andriy M
What allows SQL Server to trade an object name for a string passed to a system procedure
sql-server
JJS JJS
4 The first argument to the system stored procedure [`sp_helptext`](https://msdn.microsoft.com/en-us/library/ms176112.aspx) is:
SE Anon or Wiki user
chat
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.