Full Unicode/Ansi-Support in /testing branch

Post by **EgonHugeist** » 05.10.2012, 20:24

miab3,

thanks for you congratulations, Michal! If you're in Germany i owe some beers! And tnx for the approval of the lately done work!

Post by **mdaems** » 09.10.2012, 00:13

Time to close this thread and make more specific ones. So we might get better search results. As by now I think this mega-thread will show up in every search operation.

Mark

miab3 · Post by **miab3** » 14.10.2012, 14:24

EgonHugeist,

Zeos7.0.1-beta branches_ testing_r1918:

http://svn.code.sf.net/p/zeoslib/code-0 ... s/testing/

compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++32,
- Lazarus Win 1.1/fpc 2.7.1 32/64,
- Lazarus Lin 1.1/fpc 2.7.1 64 on Debian 64-bit (LMDE 201204).

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.27, Oracle 11g EE, PostgreSQL 9.2.1, MSSQL 2008 R2 Express - ado, mssql, FreeTDS)

One remark:
For FreeTDS and MSSQL and Lazarus Lin / Win.
Characters are truncated, and for example in field CHAR (10) fit 10 English characters and 5 national characters.
In Delphi is well.

Michal

miab3 · Post by **miab3** » 17.10.2012, 11:38

EgonHugeist,

Zeos7.0.1-beta branches_ testing_r1922:

http://svn.code.sf.net/p/zeoslib/code-0 ... s/testing/

compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++32,
- Lazarus Win 1.1/fpc 2.7.1 32/64,
- Lazarus Lin 1.1/fpc 2.7.1 64 on Debian 64-bit (LMDE 201204).

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.27, Oracle 11g EE, PostgreSQL 9.2.1, MSSQL 2008 R2 Express - ado, mssql, FreeTDS(lazarus error))

Michal

Post by **EgonHugeist** » 17.10.2012, 17:49

miab3,

thanks again.

For FreeTDS and MSSQL and Lazarus Lin / Win.
Characters are truncated, and for example in field CHAR (10) fit 10 English characters and 5 national characters.

That's an issue of UTF8 string vs. AnsiString. Actually i had not the time to use the FPC proposed FreeTDS library. As far as i know do they support the libiconv.dll which is able to convert charset to the expected Codepage.

FreeTDS(lazarus error)

Related to my previous hint?

miab3 · Post by **miab3** » 17.10.2012, 18:08

EgonHugeist,

FPC proposed FreeTDS and Debian FreeTDS library make the same mistake.

Michal

miab3 · Post by **miab3** » 20.10.2012, 14:50

EgonHugeist,

Michael, from what I can see it UIB has implemented Firebird 3.0:
http://uib.svn.sourceforge.net/viewvc/uib/trunk/
https://uib.svn.sourceforge.net/svnroot/uib/trunk/
Maybe you look how hard would be to add it to Zeos.
(For now, I connect to the Firebird 3.0 using the 2.5.3 client.)

michal

Post by **EgonHugeist** » 21.10.2012, 19:51

miab3,

nice. I'll have a look to FB3 if i'm ready with my personal intention todo.

Actually i'm fighting with the Encoding issue and FreeTDS/MsSQL + FPC. I have an solution with either Windows OR LConvertEncoding of Lazarus + PrepepareSQL=True(planning to rename it to AutoEncodeString). Well actually this little patch means again 6000 lines changed and i've to fix some of our test. I've added a new property: ControlsCodePage which decides if AutoEncodingString=True the Codepage which the controls do expect. I'm not 100% ready but if i'm than you can use FreeTDS like in delphi without any code changes..........

Post by **EgonHugeist** » 22.10.2012, 22:21

miab3,

have a look to http://www.lazarus.freepascal.org/index ... 311.0.html

I've managed the FreeTDS+Lazarus encoding stuff. Feel free to test it..

Also does that patch include some more features: you can now open a utf8connection with D7-D2007 and edit/display all chars corectly if AutoEncodeString(was PreprepareSQL) is True and TZConnection.ControlsCodePage = cGET_ACP.

For the fpc issue the settings have to be reverted..

miab3 · Post by **miab3** » 23.10.2012, 00:04

EgonHugeist,

After r1928:
It works in Delphi 2006, Delphi XE2, Lazarus Win.
Does not work in Lazarus Lin - AutoEncodeString can not switch to True.

Michal

Post by **EgonHugeist** » 23.10.2012, 07:22

miab3,

maybe this compiler directive gives the answer why:

{$IF (defined(MSWINDOWS) and not defined(WINCE)) or defined(DELPHI) or defined(WITH_LCONVENCODING)}

On non Windows plattforms do the functions i call not exsits. Thats why i've added the LConvEncoding unit from Lazarus. But actually we are not allowed to provide this unit(which would happen without Lazarus) so i've added the functionality with the WITH_LCONVENCODING define in ZeoaLazarus.inc. (we need this unit only on non MsWindows plattforms)

So uncomment:

{.$IFNDEF MSWINDOWS}
{.$DEFINE WITH_LCONVENCODING} //Only available for Lazarus to activate the LConv uncomment this define
{.$ENDIF}

by removing the dots and it should work. (I had some extra defines before to test it on windows), compile the ZComponentpackage and Lazarus again and it should work.

Post by **EgonHugeist** » 23.10.2012, 07:53

Do you have a FreeTDS lib for *nix systems?

miab3 · Post by **miab3** » 23.10.2012, 07:57

EgonHugeist,

After uncommenting this work also in Lazarus for Linux.

Yes I have a FreeTDS lib for *nix systems (Debian 64-bit).

Michal

Post by **EgonHugeist** » 23.10.2012, 08:09

miab3,

Oh did you made this lib by your selves? If so than i need your help to get the stored procs running which currently do return nothing. What about 32Bit?

Would you share it? That would be cool. I would like to add it to our lib's. We are alloed to provide a compiled version..

miab3 · Post by **miab3** » 23.10.2012, 08:16

EgonHugeist,

I got it from the distribution Debian Mint 64-bit (LMDE 201204)
But I see that it is in Debian repository:
http://packages.debian.org/en/sid/freetds-dev
I can not quickly check the a 32-bit because I have installed Linux 64-bit only.

Michal