Zeoslib Portal

@EgonHugeist

Zeos7eh1392 compiles and runs on Win7 32/64 on D2006, DXE2 32/64 and Lazarus 1.1/Fpc 2.7.1 32/64.

Michal Abramczyk

@EgonHugeist

What's this UTF8StringsAsWideField in TZConnection.
And why in the Lazarus Win it may be only a False, in DXE2 only True
and in D2006 True or False?

Michal

Today I installed PostgreSQL 9.1.4-64 bits. Everything works fine on D2006, DXE232/64, and Lazarus Win 32/64. On the server and three computers Win7 32/64, Win 7 32 and Vista 32 after installing the appropriate client libraries to the appropriate system directories or in the application directory. Z...

@EgonHugeist Michael, I have two questions: I'm curious if anyone has already tried to ZEOS FreeTDS in Linux(to MS SQL)? Since ADO works as it is difficult to adapt it to fpc and Linux. Though some passages such as ODBC. Or just standalone ODBC? These are the questions, of course, not only about you...

@EgonHugeist

Now in DXE2 works how in D2006.

Michal

@EgonHugeist

I comment line 419:

// if (FClientCodePage <> sMy_client_Char_Set) then

but nothing has changed.

character_set_client - utf8
character_set_connection - utf8

Michal

@EgonHugeist

I noticed that only mssql dbc files do not contain the directive {$IFDEF DELPHI12_UP}
Was only there was full compliance MySQL version unicode and non unicode?

Michal

@EgonHugeist

Editing dbgrid.

Seems to me that that record to the database by DXE2 is incorrect.
Because the D2006 and DXE2 read it the same.

Michal

@EgonHugeist I know what's going on. For DelphiXE2 after the introduction of national characters (for example MySQL table which I wrote) are stored in a database malfunction. In D2006 is correct. Insert: D2006 Ać DXE2 Ać Return: D2006 Ać DXE2 Ać Connection: object ZConnection1: TZConnection UTF8Str...

@EgonHugeist

But what do I do if I get a database with tables filled with data from different charsets and I can not change them but I have to use them and update?

Short as possible. Why not work with a different encoding different table fields? It is after all in many bases are provided.

Michal

@EgonHugeist The bit field in MS SQL are still problems. But I am about something else. How to operate several CharacterSet in one table in MySQL? For example, this: CREATE TABLE t5 ( Lp Integer(11) NOT NULL AUTO_INCREMENT, Nazwa VarChar(20) CHARACTER SET cp1250 COLLATE cp1250_polish_ci NOT NULL, N...

@EgonHugeist

I tested:

{$IFDEF DELPHI12_UP}
ftString:
begin
StrCopy(PAnsiChar(Buffer), PAnsiChar(AnsiString(RowAccessor.GetString(ColumnIndex, Result))));
Result := not Result;
end;
{$ENDIF}

and it seems that is well.

Michal

@EgonHugeist

It should be here
http://www.microsoft.com/en-us/download ... x?id=23654
Inside is also SQL creation script.

Michal

@EgonHugeist

I encountered a problem with the field(MS SQL):
Discontinued bit NOT NULL
In the Products table.
It is interpreted as a boolean and can only be true.

Michal

@EgonHugeist

For me the extra characters at the end of the field shown in a simple DBGrid(in rev 1377).

Michal Abramczyk