When open database
I tested Firebird ODBC driver using with BDE on Delphi11.2.
I get error when openning TTable, "Dynamic SQL Error. Column unkown ID at line 1, column 8."
I create database on Firebird 3.0.10, then create OBDC DataSoure using ODBC administrator with CharacterSet=SJIS_0208, connection test is OK.
I create simple VCL Form Application with BDE using TDatabase, TTable, TDBGrid, each params are set correctly.
TDatabase open is OK, but TTable can't open with error.
Firebird Project ODBC driver is passed this test with no error.
Is Devart ODBC driver broken???
-- CREATE DATABASE with UTF8
CREATE DATABASE 'localhost:C:\DATABASE\FIREBIRD\ODBCTEST_UTF8.FDB' USER 'sysdba' password 'NR5fBhMg' PAGE_SIZE 16384
DEFAULT CHARACTER SET SJIS_0208;
-- CREATE TABLE tbltest
CREATE TABLE tbltest (
id integer not null primary key,
* I tested many case with charactroset UTF8, SJIS_0208, CP943C, using Firebird Project ODBC driver, Devart ODBC driver, Easysoft ODBC driver. DB=UTF8-CLIENT=UTF8, DB=UTF8-CLIENT=SJIS_0208, and so. All test cases shows Devart ODBC driver can't open Table any way.
* Firebird Project driver and Easysoft ODBC driver can handling CP943C, but Devart ODBC driver can't handling CP943C. We will use CP943C.