Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Category: Firebird SQL

Digital solution partner

Charset Firebird 3.0 [malformed string error]

Character set encoding In Firebird 3.0, as is known in a field of a varchar or char type table, it is possible to define the type of encoding managed, or not specific. Through Firebird it is possible to record the content of the story from one set of characters and another simply with the SQL…
Read more

Firebird Performance Tour 2019 – Prague

  Synaptica has always adopted Firebird as its main database environment for the realization of many solutions from embedded iot products to Web solutions with thousands of daily accesses. Firebird proved to be a great tool, flexible and easy to manage. For this reason we could not miss the appointment to meet the creators (Dmitry…
Read more

Firebird Sql Tips… Enable or Disable all trigger via sql

To enable and disable all triggers of a database i do two procedure : Enabling all database trigger:

Disabling all database trigger:

Firebird SQL & Interbase list of all foreign keys

With that simple peace of code you can retrive the full list of all “FK” Foreign Key of an Interbase or Firebird DB.

Firebird embedded on mac-osx

Users/ivanrevelli/Downloads/Firebird.app/Contents/MacOS/firebird/ cd Users/ivanrevelli/Downloads/Firebird.app/Contents/MacOS/ Users/ivanrevelli/Downloads/Firebird.app/Contents/MacOS/firebird/libfbembed.dylib