Subject Filter non ISO8859_1 characters
Author nols_smit

I have a FireBird 2.5 database, created to use the ISO8859_1 character set. On a monthly interval, I re-create a new empty database (except for a few lookup tables) by restoring a backup, dump data from an Oracle database and load the mentioned empty database. I then do some indexing using Href Tools Corp. Rubicon indexing components (the same one used on My web application is

It now seems that non ISO8859_1 characters are slipping thru and they are causing problems during the Rubicon indexing.

Does anyone know how can I filter out any non ISO8859_1 characters during the load process? I'm using Delphi7 and the UniDac database drivers.


Nols Smit