Story Category: Database Development
VOTEWhen MySQL characterset ‘utf’ does not allow you to enter some Unicode code points
jpluimers
Contrary to what many believe is that MySQL utf8 is not always full blown UTF-8 support, but actually utf8mb3, which has been deprecated for a while now. Only utf8mb4 will give you full blown UTF-8 support…. … Read more
2 years ago in Conference Topics, Conferences, Database Development, Delphi, Development, Encoding, Event, MYSQL, Software Development, UTF-8, UTF8
0
delphi – How to enable wirecompression on Firebird 3.0 – Stack Overflow
jpluimers
For my link archive: [WayBack] delphi – How to enable wirecompression on Firebird 3.0 – Stack Overflow [WayBack] delphi – How to enable WireCompression on Firebird 3.0 using FireDAC – Stack Overflow –jeroen … Read more
3 years ago in Database Development, Delphi, Development, Firebird, Software Development
0
ODAC: calling SYS.DBMS_SESSION.SET_NLS failing with ORA-06550/PLS-00103
jpluimers
Do not call SYS.DBMS_SESSION.SET_NLS with an instance of the [Archive.is] TOraStoredProc Class, as under the hood, it will translate the call to this: Class:Ora.TOraStoredProc;Component:sprSetNls;Flag:tfQPrepare,Text:Prepare: begin SYS.DBMS_SESSION.SET_NLS(:PARAM, :VALUE); end; :PARAM(VARCHAR[22],IN)=’NLS_NUMERIC_CHARACTERS’ :VALUE(VARCHAR[4],IN)=”.,” The above is a translation… … Read more
3 years ago in Database Development, Delphi, Development, OracleDB, Software Development
0
ODAC undocumented exception ‘Need Oracle 8 Call Interface’
jpluimers
I got this when taking over maintenance of some legacy code that called a stored procedure in a : ————————— Debugger Exception Notification ————————— Project LegacyProject.exe raised exception class Exception with message ‘Need Oracle 8… … Read more
3 years ago in Database Development, Delphi, Development, OracleDB, Software Development
0
SQL Server: RowVersion is not the same format as BigInt
jpluimers
A while ago, I needed to get RowVersion binary data out of SQL Server. People around me told me it is stored as BigInt. I luckily bumped into [WayBack] sql server – Cast rowversion to… … Read more
3 years ago in .NET, Database Development, Delphi, Development, Software Development, SQL Server
0
FireDAC can do DBMS back-end conditional SQL via Conditional Substitution
jpluimers
Though the field-types mentioned in the problem and solution are equal (so either is wrong), the solution in [WayBack] I have a little problem with FireDAC and the TStringField and TWideStringField design time generation… – Juan… … Read more
4 years ago in Database Development, Delphi, Development, Firebird, InterBase, Software Development, SQL, SQL Server
0
In SQL Server use `SET NOCOUNT ON` so tools taking the last modified record count won’t be confused by your trigger.
jpluimers
Interesting read: Time eating bug of the day… – Fabian S. Biehn – Google+. TL;DR: in SQL Server use SET NOCOUNT ON so tools taking the last modified record count won’t be confused by your trigger…. … Read more
4 years ago in Database Development, Delphi, Development, Office VBA, Scripting, Software Development, SQL, SQL Server
0