mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

畅雨 · 2013-10-25 08:35:32

Test : mssql server2012 + syndbZEOS : If fieldname has some Asian languages(Double-byte characters) then error,
but oledb,firedac,sqlite3 is correct .

eg: SQL= select  'changyu畅雨' as 姓名   , the result ： [{"濮撳悕":"changyu畅雨"}]      , remark: '姓名' = 'name'

The fieldname is wrong, but fieldvalue is correct !

 SynDBZEOS.pas  line 544
  ...
  for i := 1 to fResultInfo.GetColumnCount do begin
      name := (fResultInfo.GetColumnLabel(i));    -----maybe has error?
      if name='' then
        name := (fResultInfo.GetColumnName(i));  -----maybe has error?
  ...

But I do not know how to fix it ...

Last edited by 畅雨 (2013-10-25 08:40:27)

ab · 2013-10-25 11:54:43

Which version of Delphi are you using?
Which version of Zeos/ZDBC?
Did you try with another DB backend?

畅雨 · 2013-10-25 12:00:33

delphi7, zeos: 7.1.2

ab · 2013-10-25 12:03:31

We did test only English-based column names, since our ORM and our own code style expect this behavior...

The SynDBZeos unit code uses a plain "name: string" variable, then StringToUTF8() to make the conversion...
Could you step in those lines using the debugger, and check the "name: string" content?

畅雨 · 2013-10-25 12:17:05

OK, I try

ab · 2013-10-25 12:19:22

It may be a ZEOS/ZDBC problem under Delphi 7.

Or perhaps the returned "AnsiString" is UTF-8 encoded in non Unicode Delphi versions...

畅雨 · 2013-10-25 12:26:35

SynDBZEOS.pas line 548
...
PSQLDBColumnProperty(fColumn.AddAndMakeUniqueName(StringToUTF8(name)))^.
...
replace as:
PSQLDBColumnProperty(fColumn.AddAndMakeUniqueName(name))^.

remove StringToUTF8 , result is correct !

I guess Coding has been processed by zeos, the returned 'name' is UTF-8 encoded?

Last edited by 畅雨 (2013-10-25 12:30:15)

ab · 2013-10-25 13:20:09

I guess this is for non-Unicode Delphi only...

Should be fixed by http://synopse.info/fossil/info/405d06b156

mORMot Open Source

#1 2013-10-25 08:35:32

mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

#2 2013-10-25 11:54:43

Re: mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

#3 2013-10-25 12:00:33

Re: mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

#4 2013-10-25 12:03:31

Re: mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

#5 2013-10-25 12:17:05

Re: mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

#6 2013-10-25 12:19:22

Re: mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

#7 2013-10-25 12:26:35

Re: mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

#8 2013-10-25 13:20:09

Re: mssql server2012 + syndbZEOS : If fieldname has some Asian languages(

Board footer