Recently I have faced a challenge. I had a big database (about 3GB of data, hundreds of tables) and I needed to change the collation for all the CHAR and VARCHAR columns. How to do it it? Is there an easy way?
Showing posts with label firebird. Show all posts
Showing posts with label firebird. Show all posts
Wednesday, November 20, 2013
Sunday, February 05, 2012
Firebird and Unicode databases
The first encounter with unicode databases and collations on Firebird may be confusing, as it was for me and it may take some time to grasp the concepts and settings. This article describes the principles and catches and gives the examples how to set up a UTF-8 database in Firebird SQL server 2.5, how to setup ICU libraries and how to use national collations (eg. czech).
Wednesday, August 18, 2010
Building the Qt FireBird SQL driver
The Qt toolkit contains many great SQL drivers and among them is also an InterBase / FireBird SQL driver. But the Windows version of the toolkit ships with SQLite and ODBC driver binaries only. The other ones have to be built by ourseleves. This article describes how to build the FireBird driver using MinGW 32bit version of Qt 4.6 for Windows.
Subscribe to:
Posts (Atom)