I'm having a problem with getting data out of an IB db using Free
IBProvider odbc driver.

I'm trying to pull the data using ADO, to push the data into an
Access db.

The problem is, some of the IB data contains the trademark symbol
(™), and it's causing an error.


err
-2147467259

error
Fetch:
SQLCODE=-802:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
IBCODE=isc_arith_except

Here's the sample text:

FEM™ PRO

When I view the data through IBConsole, it doesn't appear properly,
it doesn't show the ™ symbol, in either the tableview, or
Interactive SQL, but when I copy and paste that text into anything
in Windows XP, it shows the text properly.

The character set for the database seems to be default.
From IBConsole, View Metadata:

/* CREATE DATABASE 'C:\Temp\condata.dat' PAGE_SIZE 4096

DEFAULT CHARACTER SET */

I've tried a few character types in the connection string

IBdbSource = 'C:\Temp\condata.dat'

adoIBConn.ConnectionString = "provider=LCPI.IBProvider;data
source=localhost:" & _
IBdbSource
& ";ctype=win1251;" & _
"user
id=SYSDBA;password=masterkey"

I've tried
ctype=win1251
ctype=win1252
ctype=win1254
ctype=unicode_fss

I'm also not getting the text out of blob fields properly, not sure
if this is an indicator of a larger issue or not.

Any help would be greatly appreciated.

Thanks
Mark