Full Unicode/Ansi-Support in /testing branch
Moderators: gto, EgonHugeist, olehs
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
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!
thanks for you congratulations, Michal! If you're in Germany i owe some beers! And tnx for the approval of the lately done work!
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
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
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
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
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
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
miab3,
thanks again.
thanks again.
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.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.
Related to my previous hint?FreeTDS(lazarus error)
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
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
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
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
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..........
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..........
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
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..
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..
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
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.
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.
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Do you have a FreeTDS lib for *nix systems?
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
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..
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..
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
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
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