Discussion:
[Firebird-odbc-devel] MS Access #deleted with varchar UTF8 primary key
Carsten Ulrich
2011-05-18 13:49:50 UTC
Permalink
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
Henner Kollmann
2011-05-23 11:50:23 UTC
Permalink
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-----
Gesendet: Mittwoch, 18. Mai 2011 15:50
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Jorge Andrés Brugger
2015-02-09 15:57:56 UTC
Permalink
Hi.

I´m using 2.0.3.154 odbc driver and a similar issue.

Was the patch merged into ODBC driver?

Thanks!
Post by Henner Kollmann
This is a problem using UTF-8.
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-----
Gesendet: Mittwoch, 18. Mai 2011 15:50
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
--
Jorge Andrés Brugger
Departamento de Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: ***@dasu.com.ar
Website: www.dasu.com.ar

"No podemos resolver problemas pensando de la misma manera que cuando los creamos" (Albert Einstein)


--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.
Alexander Potapchenko
2015-02-10 07:11:51 UTC
Permalink
Hi,

There is no universal patch for Firebird ODBC driver now.
I made special build here - http://tracker.firebirdsql.org/browse/ODBC-124.
Post by Jorge Andrés Brugger
Hi.
I´m using 2.0.3.154 odbc driver and a similar issue.
Was the patch merged into ODBC driver?
Thanks!
Post by Henner Kollmann
This is a problem using UTF-8.
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-----
Gesendet: Mittwoch, 18. Mai 2011 15:50
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
--
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru
Jorge Andrés Brugger
2015-02-10 12:03:41 UTC
Permalink
Thanks Alexander.

The patched driver works with Win7 and Access 2013.

I know it´s a MS Access issue, but there is any chance to integrate the
"fix" someway in Firebird ODBC driver?

Regards!
Post by Alexander Potapchenko
Hi,
There is no universal patch for Firebird ODBC driver now.
I made special build here - http://tracker.firebirdsql.org/browse/ODBC-124.
Post by Jorge Andrés Brugger
Hi.
I´m using 2.0.3.154 odbc driver and a similar issue.
Was the patch merged into ODBC driver?
Thanks!
Post by Henner Kollmann
This is a problem using UTF-8.
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-----
Gesendet: Mittwoch, 18. Mai 2011 15:50
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
--
Jorge Andrés Brugger
Departamento de Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: ***@dasu.com.ar
Website: www.dasu.com.ar

"El verdadero modo de no saber nada es aprenderlo todo a la vez." (George Sand)


--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.
Alexander Potapchenko
2015-02-10 12:20:29 UTC
Permalink
Jorge,

It is a not priority improvement at this moment, but I can build special
installers with this fix for a while.
Post by Jorge Andrés Brugger
Thanks Alexander.
The patched driver works with Win7 and Access 2013.
I know it´s a MS Access issue, but there is any chance to integrate the
"fix" someway in Firebird ODBC driver?
Regards!
Post by Alexander Potapchenko
Hi,
There is no universal patch for Firebird ODBC driver now.
I made special build here - http://tracker.firebirdsql.org/browse/ODBC-124.
Post by Jorge Andrés Brugger
Hi.
I´m using 2.0.3.154 odbc driver and a similar issue.
Was the patch merged into ODBC driver?
Thanks!
Post by Henner Kollmann
This is a problem using UTF-8.
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-----
Gesendet: Mittwoch, 18. Mai 2011 15:50
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
------------------------------------------------------------------------------
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
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
--
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru
Loading...