Re: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8 primary key

[Henner K. <Hen...@gm...>]

This is a problem using UTF-8. 

It's described here:

http://www.easysoft.com/support/kb/kb00929.html.


I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR
and created a new MsVc90 project to generate an odbc driver named "Firebird
driver for MS Access".

This new driver works with MS Access 2003 and 2007 with Unicode databases.

Regards,
Henner

> -----Ursprüngliche Nachricht-----
> Von: Carsten Ulrich [mailto:Car...@mo...]
> Gesendet: Mittwoch, 18. Mai 2011 15:50
> An: fir...@li...
> Betreff: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8
primary
> key
> 
> Hello,
> I want to open a table where the primary key is a varchar(50) Column with
> charset utf8. MS Access (2010) shows the Value #deleted for all columns.
If I
> change the charset of the primary key column to ISO8859_1 it works.
> 
> I use ODBC driver version 2.00.00.151
> 
> Thanks
> Carsten
> 
>
----------------------------------------------------------------------------
--
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its next-
> generation tools to help Windows* and Linux* C/C++ and Fortran developers
> boost performance applications - including clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel