Discussion:
[Firebird-odbc-devel] unicode problem with Microsoft Query
ching lu
2015-06-09 12:21:22 UTC
Permalink
The testing environment is Win7 SP1 64 bit, Office 2010 64 bit,
Firebird 2.5.4 x64 embedded server, Firebird_ODBC_2.0.3.154_x64

I need to work with unicode table names and unicode column names.

The embedded database (charset=UTF8) is created with flamerobin x64,
the table names and column names worked ok

When i test with Excel (odbc client charset and server:are both UTF8)

1. The names are garbage characters when trying to with "Microsoft query"
2. The query works ok except for blob text column, it is garbage characters

Please help me

------------------------------------------------------------------------------
ching lu
2015-06-10 01:30:12 UTC
Permalink
please find the screenshots:
https://drive.google.com/folderview?id=0B8V-YFTM0I7Ffm5CVkE3SElZMGQ1R2F1MkFFRU1VckJOYVJqaEJHWm1ibXFzeUhoczRvMkU&usp=sharing
Post by ching lu
The testing environment is Win7 SP1 64 bit, Office 2010 64 bit,
Firebird 2.5.4 x64 embedded server, Firebird_ODBC_2.0.3.154_x64
I need to work with unicode table names and unicode column names.
The embedded database (charset=UTF8) is created with flamerobin x64,
the table names and column names worked ok
When i test with Excel (odbc client charset and server:are both UTF8)
1. The names are garbage characters when trying to with "Microsoft query"
2. The query works ok except for blob text column, it is garbage characters
Please help me
------------------------------------------------------------------------------
ching lu
2015-06-11 13:34:08 UTC
Permalink
Can someone helps? Thx.
Post by ching lu
https://drive.google.com/folderview?id=0B8V-YFTM0I7Ffm5CVkE3SElZMGQ1R2F1MkFFRU1VckJOYVJqaEJHWm1ibXFzeUhoczRvMkU&usp=sharing
Post by ching lu
The testing environment is Win7 SP1 64 bit, Office 2010 64 bit,
Firebird 2.5.4 x64 embedded server, Firebird_ODBC_2.0.3.154_x64
I need to work with unicode table names and unicode column names.
The embedded database (charset=UTF8) is created with flamerobin x64,
the table names and column names worked ok
When i test with Excel (odbc client charset and server:are both UTF8)
1. The names are garbage characters when trying to with "Microsoft query"
2. The query works ok except for blob text column, it is garbage characters
Please help me
------------------------------------------------------------------------------
Loading...