BLOB text column is not transliteration with UTF8 connection. [ODBC44] #42
Comments
|
Commented by: @alexpotapchenko I think it is not a bug of ODBC driver. |
|
Commented by: Minoru Yoshida (timeful2) Thanks for your comment. >May be these columns contains only english characters? No. Testing charsets are japanese value in VARCHAR/CHAR of UTF8 . I try another case, - FB V2.0 default charset : SJIS_0208 The BLOB column's transliteration is fine. |
|
Commented by: Tao Lin (taol) I am using Delphi 2009 with ADOConnection. My configure: Delphi 2009, Win XP sp2, Fb 2.1, build 144. My database's default character is UTF8. When it load the data from the database by FbODBC, varchar can return Chinese correct, but Blob field is not. I find out is that if I make the TADOQuery memo field from TMemoField to TWideMemoField, then the Chinese character dispaly correctly. Because I don't have build 143, I don't whether the bug is introudce from 144, maybe someone can send me a odbcfb32.dll build 143 for testing. |
|
Commented by: Minoru Yoshida (timeful2) I retry it with RC1(Build 148 ) . My environment: - FB V2.0.4 Case 1. Defaut charset :UTF8 - VARCHAR is fine Case 2. Default charset:SJIS_0208 - VARCHAR is fine I think that result must be the same at client connection is UTF8. Why is a result different? |
|
Commented by: @alexpotapchenko I have understood with this problem. |
Modified by: @alexpotapchenkoassignee: Vladimir Tsvigun [ praktik ] => Alexander Potapchenko [ lightfore ] |
|
Commented by: @alexpotapchenko Do you confirm it? ODBC driver is only an intermediate layer between a server and a client application (ADO in this case). The driver transfers data to a client application in the form which a server returns their. |
Modified by: @alexpotapchenkostatus: Open [ 1 ] => Resolved [ 5 ] resolution: Won't Fix [ 2 ] Fix Version: 2.0 RC1 [ 10310 ] |
|
Commented by: Minoru Yoshida (timeful2) I am usually using IBObject on FB2.0.4. The UTF8 BLOB column handling is no ploblem(This mean is *no* transliteration at any charset connection). IBProvider Free Edition 32 bit >This is a bug of Firebird 2.0. invalid BLOB ID on blob with different charset Is your saying this? My case is same(Defaut =Connection) charset. >- FB V2.0.4 >Case 1. Defaut charset :UTF8 >- VARCHAR is fine |
|
Commented by: @alexpotapchenko invalid BLOB ID on blob with different charset |
|
Commented by: Minoru Yoshida (timeful2) >It explains your Case 1 and Case 2. Thanks for your explanation. i have understood. >You can try Firebird 2.1.1 (backup/restore of the database is required) and you will see an identical behaviour in both cases. I retry it on V2.1.1( and V2.5 Alpha). My environment: - FB V2.1.1 Case 1. Defaut charset :UTF8 - VARCHAR is fine Case 2. Default charset:SJIS_0208 - Result recordset is empty .( and V2.5 result is the same, too) My another application works fine in both cases(Using IBO). I have not clear understanding... |
|
Commented by: @alexpotapchenko Result recordset is empty? What is It meaning? |
|
Commented by: Minoru Yoshida (timeful2) Sorry, i had mistake. This case is another case. >My environment: >- FB V2.1.1 Case 1. Defaut charset :UTF8 Client connection:UTF8 >- VARCHAR is fine Case 2. Default charset:SJIS_0208 Client connection:UTF8 >- VARCHAR is fine >Result recordset is empty? What is It meaning? This mean is recordSet.EOF as bellow case 3. My test code: Case 3. Defaut charset :UTF8 Client connection:SJIS_0208 - Result recordset is empty .( and V2.5 result is the same, too) As far as i know , This case issue an arithmetic error from server. because my data have the over SJIS_0208 range charset. Is this specification of ODBC driver? |
|
Commented by: @alexpotapchenko I have absolutely got confused in your non-reproducible cases at me. |
|
Commented by: Minoru Yoshida (timeful2) >1) You must use Firebird 2.1 >- FB V2.1.1 >2) Database ODS must be > = 11.1 (if database was created in Firebird 1.5 or 2.0 then backup/restore is required) Yes. >Case 3. Defaut charset :UTF8 Client connection:SJIS_0208 I try it with IBProvidor. I get -214217837(80049e53) automation error. My ploblem is this case only. Thanks for your kindly anser. |
|
Commented by: @alexpotapchenko I have told that ADO does not translate BLOB fields anyway. |
|
Commented by: Minoru Yoshida (timeful2) >Can you reproduce it with fb2.1, odc 11.1 and ODBC driver? I retry it now on FB2.1. >Case 2. Default charset:SJIS_0208 Client connection:UTF8 Your saying is correct, i was mistaken about the IBProvidor's result. |
Modified by: @alexpotapchenkostatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Minoru Yoshida (timeful2)
Votes: 1
I'm testing for OdbcFb_v2_0_145_Win32.
The VARCHAR/CHAR columns are working fine with UTF8 connection.
But BLOB text column is not transliteration.
I tried change to the CP943C connection. This BLOB's transliteration is fine.
I think that UTF8 connectioin result is odbc driver side bug since build 144.
My environments:
- WindowsXP sp2
- Firebird V2.1.1
- Excel 2003 japanese edition.
/* Create database */
CREATE DATABASE 'Localhost:TestDB'
USER 'sysdba'
PASSWORD 'password'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UTF8;
SET SQL DIALECT 3;
/* Create table */
CREATE TABLE Table1 (
K INTEGER NOT NULL, B BLOB SUB_TYPE TEXT SEGMENT SIZE 80
, CONSTRAINT PK PRIMARY KEY (K));
-- My test code
Sub Fbodbctest()
Dim con As ADODB.Connection
Dim recordSet As ADODB.recordSet
Dim outPutSheet As Worksheet
Dim row As Long
Dim col As Long
'
con.Open "DRIVER=Firebird/InterBase(r) driver; SERVER=localhost; DATABASE=TestDB;" & _
"Extended Properties=""UID=sysdba;PWD=password;CHARSET=UTF8;"""
' "Extended Properties=""UID=sysdba;PWD=password;CHARSET=CP943C;"""
recordSet.Open "select * from Table1", con, adOpenForwardOnly, adLockReadOnly, -1
'Field values to row
row = 2
While (Not recordSet.EOF) And row < 60000
For col = 0 To recordSet.Fields.Count - 1
outPutSheet.Cells(row, col + 1).Value = recordSet.Fields(col).Value
Next col
recordSet.MoveNext
row = row + 1
Wend
End Sub
--
Regards,
Minoru
The text was updated successfully, but these errors were encountered: