Zeoslib Portal

EgonHugeist wrote:touchring,

great! Hint: replace dwflags with 0 for function WideCharToMultiByte. It's so much faster!

Thanks for the hint.

Hi Michael, I've decided to encode in specific page code instead of UTF8 which appears to work for MSSQL and Zeoslib. function WideStringToString(const ws: WideString; codePage: Word): AnsiString; var l: integer; begin if ws = '' then Result := '' else begin l := WideCharToMultiByte(codePage, WC_COM...

Hi Michael, thanks. I'm able to get it work partially by encoding the data as UTF-8 (your code to encode the entire SQL string works also) however, SQL Server doesn't support UTF8 fully, so some characters are lost - http://stackoverflow.com/questions/12512687/sql-server-utf8-howto I've verified tha...

Hi EgonHugeist , thanks for replying. D7 doesn't support Wide-String/Memo fields. Thought TNT needs WideFields, so i'm starting from the premisse you made your own UTF8 hack? I've not made any changes to zeoslib. From what I know, D7 supports UTF-8 string manipulation and conversion from codepages t...

Hi, I'm having trouble inserting Unicode into an SQL Server 2008 database using ZeosLib 7.0.3 and D7. I've created a simple test program that first inserts and then queries the inserted value to see if it has been inserted properly. The test table schema: CREATE TABLE [dbo].[incominglog]( [message] ...

I've copied all the DLLs in C:\Program Files\PostgreSQL\8.4\bin to my delphi app folder, yet i am still getting this error -

Can't connect to database. None of the dynamic libraries can be found: libpq81.dll, libpq.dll

Any thoughts? Thanks.

Hi, it has been 1 year since, does zeolibs still connect to mssql from linux platform? Thanks.

I'm a newbie, the crypted version of SQLite costs $2000, which is a reasonable price for a commercial project considering that it covers future versions, but for my proof of concept personal project, this is beyond my budget. Has anyone research on an alternative, like say encrypting each field inst...

Don't leave ZConn.TransactionIsolationLevel to tiNone. Change it ( eg. readCommited ) or StartTransaction, Commit and Rollback methods wont work. Thanks, i've tried this method, it does speed up the inserts tremendously, but there's a problem - when i tried to do a select on the same table at the s...