Search found 12 matches

by ibrahim
22.09.2010, 11:33
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] Delphi 2010 + MySQL + UTF8
Replies: 51
Views: 13559

Hi Mark, I'm sorry but I read your post just today. Here is in attachment the files I changed. You will find //IBRAHIM comment in them where I changed the code. I included also an Interbas/Firebid file that helps to solve the UFT8 problems with firebird/interbase as I wrote in this topic http://zeos...
by ibrahim
17.09.2010, 18:49
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos 7 Alpha and Delphi 2009 Support - Official Thread
Replies: 97
Views: 28234

Hi to you all, About strings and UTF8 in Delphi 2009 I noticed that if you put three labels on a form and you use this code Var S : String begin S :='انجليزي'; Label1.Caption := S; Label2.Caption := AnsiString(S); Label3.Caption := AnsiString(UTF8String(S)); You will get Label1 and Label 3 showing t...
by ibrahim
17.09.2010, 10:11
Forum: ZeosLib 7.0 Beta Forum
Topic: Delphi 2009 With firebird 2.1 and UTF8
Replies: 6
Views: 1150

Hi to all, Since I noticed a similar question about UTF8 and My sql (look here http://zeos.firmos.at/viewtopic.php?t=2652 ) I made some debug for both databases (MySql and Firebird) and I found some solutions for it with delphi 2009. There is a common part in the above post that works also for Inter...
by ibrahim
15.09.2010, 15:01
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] Delphi 2010 + MySQL + UTF8
Replies: 51
Views: 13559

Hi to you all, I made a lot of debug today and I think/hope that I found a solution for the UTF8 problem with MySql. This solved both reading and writing to database. I made a lot of debug and I noticed that the problems come out when you cast a WideString to an AnsiString and pass it as a parameter...
by ibrahim
15.09.2010, 09:20
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] Delphi 2010 + MySQL + UTF8
Replies: 51
Views: 13559

Hi to you all, I opened a topic about Firebird-Delphi2009 and UTF8. I noticed today this topic and since I have very similar results as those described here, I made a try creating a MySql database similar to my Firebird one. Here are my conclusions/observations 1- in the TZAbstractRODataset.GetField...
by ibrahim
14.09.2010, 19:08
Forum: ZeosLib 7.0 Beta Forum
Topic: Delphi 2009 With firebird 2.1 and UTF8
Replies: 6
Views: 1150

I made some debug and I found that if I replace line 1357 of the file that looks like this WStrCopy(Buffer, PWideChar(RowAccessor.GetUnicodeString(ColumnIndex, Result))); by this one WStrCopy(Buffer, PWideChar(UTF8Decode(PAnsiChar(Utf8ToAnsiEx(RowAccessor.GetUnicodeString(ColumnIndex, Result),1252))...
by ibrahim
14.09.2010, 10:52
Forum: ZeosLib 7.0 Beta Forum
Topic: Delphi 2009 With firebird 2.1 and UTF8
Replies: 6
Views: 1150

I'm getting these problems with the tdbedit and not with memo fields.
I have the same result with

codepage=utf8
client_encoding=utf8

set in the connection properies or even without them set.
by ibrahim
14.09.2010, 09:26
Forum: ZeosLib 7.0 Beta Forum
Topic: Delphi 2009 With firebird 2.1 and UTF8
Replies: 6
Views: 1150

I'm making some debug and I tried to use a TZQuery component to insert some data directly addig arabic string in it and IT WORKS!!! I use the ExecSQL procedure to execute INSERT INTO LANGUAGES VALUES (-1,'انجليزي') and the record was inserted in the database without any problem. I hope this may help...
by ibrahim
14.09.2010, 08:50
Forum: ZeosLib 7.0 Beta Forum
Topic: Delphi 2009 With firebird 2.1 and UTF8
Replies: 6
Views: 1150

P.S: Is there any documentation for programmers that may help to understand the structure of the zeos componets.
I can give you some help with the Interbase part of development and testing.
I tried to create the same database with MySql and I'm getting the same results.

Thanks
by ibrahim
14.09.2010, 08:45
Forum: ZeosLib 7.0 Beta Forum
Topic: Delphi 2009 With firebird 2.1 and UTF8
Replies: 6
Views: 1150

Delphi 2009 With firebird 2.1 and UTF8

Hi to you all. I'm writing an application with a firebird 2.1 database with utf8 char set. I use Delphi 2009 and I'm getting strange characters in my fields when I use Zeos TRUNK REV803. I created my database with UTF8 code page and one table that have a varchar field and I can insert data in it usi...
by ibrahim
07.07.2009, 20:53
Forum: 6.6 - stable
Topic: Firebird embedded with utf8 database
Replies: 2
Views: 413

I made some test to insert data with the zeos components and I after I post data I get a lot of question marks in the field like this ?????.
by ibrahim
07.07.2009, 20:33
Forum: 6.6 - stable
Topic: Firebird embedded with utf8 database
Replies: 2
Views: 413

Firebird embedded with utf8 database

Hi to you all. I'm writing an application with a firebird 2.1 database with utf8 char set. I used till now a DBX library (tbodbxfb) to insert data and I'm trying now to switch to Zeos components. I use Delphi 2007 and the Tnt components and I'm getting strange characters in my fields when I use Zeos...