Zeoslib Portal

trob

somebody?

trob

Hello I want to set a MediumBlob field in a MySQL5 db. I use this code: ZQuery1.SQL.Text:='UPDATE table SET photo=:pic WHERE key=123'; ZQuery1.Params.ParamByName('pic').Assign(Image1.Picture.Graphic); ZQuery1.ExecSQL; Now, in Zeos7 i get an error message: Unsupported data type. In the log of MySQL: ...

trob

Hello

Why is the DisplayFormat unuseable?
I set DisplayFormat of a ZReadOnlyQuery's date field to "yyyy-mm-dd", but if i use this field as AsString, it shows the date in Window's local format.

This problem was not in the old version of Zeos.

I use Delphi 2010 and Zeos 7.

Thanks.

trob

No problem, now i use the code above, and it works fine.

trob

OK.

A want to see every db-change in the MySQL log, and it logs only the SQL commands. The parameters can't be seen in the log.

I know, there are better solutions for logging, but until i programming it, i use MySQL's log.

trob

If you use some normal language, i would answer you.

Yes, i have a good reason.

trob

At the end, this is the solution:

Code: Select all

function convtodb(input: string):string;
var a: PAnsiChar;
    w: PWideChar;
Begin
  GetMem(w,255);
  GetMem(a,255);
  StringToWideChar(input,w,255);
  UnicodeToUtf8(a,w,255);
  Result:=a;
  FreeMem(w);
  FreeMem(a);
End;

trob

it does not work

It still sends in cp1250

trob

Hello

How can i send the SQL commands to the database in UTf8? I use Delphi 2010.

The DB and the fields are UTF8. I want to send datas in UTF8 too, so none of characters are lost by the Unicode > latin/cp1250 > Utf8 conversions.

trob

Hello

Does anybody have the Rave Reports 7.6.2 for the Delphi 2009?

I have the 7.6.0, on the Delphi DVD, but it does not work. I have read about this new version, what is downloadable from the Embarcadero site, but i can't login...

trob

I get the solution from the MySQL help... After connecting: ZQueryExec.SQL.Text:='SET character_set_client = utf8'; ZQueryExec.ExecSQL; ZQueryExec.SQL.Text:='SET character_set_connection = utf8'; ZQueryExec.ExecSQL; ZQueryExec.SQL.Text:='SET character_set_results = Latin2'; ZQueryExec.ExecSQL; And e...

trob

Thanks, but i have done this already. I had to, because the program did not get anything from the DB. So now all querys that read datas from the DB work fine, just the writing have this coding problem.

trob

Oh, why don't you plan to be a D2009 user? What is wrong with it?

trob

Hello, I have a program in Delphi 2009, the datas are in MySQL by Zeos7. (Yes, i know it is in alpha state.) In D2007 everything was fine, but in D2009 there is a problem with character coding. I get the datas from MySQL by TZReadOnlyQuery, and write them by TZQuery's SQL commands. The loading is fi...

trob

Hello,

Do You know when will it be Beta?

Zeoslib Portal

Search found 51 matches

ParamByName in MySql5

DisplayFormat

Send to DB in UTF8

Rave Reports 7.6.2

Delphi 2009 Unicode problem