Story Category: Database Development

1

VOTES


VOTE

When MySQL characterset ‘utf’ does not allow you to enter some Unicode code points

jpluimers 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…. – Details… 2 years ago in Conference Topics, Conferences, Database Development, Delphi, Development, Encoding, Event, MYSQL, Software Development, UTF-8, UTF8 0

1

VOTES


VOTE

delphi – How to enable wirecompression on Firebird 3.0 – Stack Overflow

jpluimers 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 – Details… 2 years ago in Database Development, Delphi, Development, Firebird, Software Development 0

1

VOTES


VOTE

ODAC: calling SYS.DBMS_SESSION.SET_NLS failing with ORA-06550/PLS-00103

jpluimers 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… – Details… 2 years ago in Database Development, Delphi, Development, OracleDB, Software Development 0

1

VOTES


VOTE

ODAC undocumented exception ‘Need Oracle 8 Call Interface’

jpluimers 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… – Details… 2 years ago in Database Development, Delphi, Development, OracleDB, Software Development 0

1

VOTES


VOTE

FireDAC can do DBMS back-end conditional SQL via Conditional Substitution

jpluimers 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… – Details… 3 years ago in Database Development, Delphi, Development, Firebird, InterBase, Software Development, SQL, SQL Server 0

1

VOTES


VOTE

In SQL Server use `SET NOCOUNT ON` so tools taking the last modified record count won’t be confused by your trigger.

jpluimers 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…. – Details… 4 years ago in Database Development, Delphi, Development, Office VBA, Scripting, Software Development, SQL, SQL Server 0