Search found 5 matches

by bobo
08.06.2011, 18:52
Forum: User Patches
Topic: [patch_done] Fix datetime to string Lazarus program MySql
Replies: 4
Views: 2632

There might be other places when something like this needs to be done for FPC/Lazarus.
The other day I again saw a lot of ?? field value returns for some simple string fields (not calculated fields, just normal db fields) on Windows (did not check on Linux).
by bobo
22.05.2011, 00:40
Forum: ZeosLib 7.0 Beta Forum
Topic: 7.0 SVN MySQL calculated field content is returned as ??
Replies: 4
Views: 753

Yes, this fixes it. Thanks.
by bobo
22.05.2011, 00:38
Forum: User Patches
Topic: [patch_done] Fix datetime to string Lazarus program MySql
Replies: 4
Views: 2632

Yes, this seems to fix it. Thank you.

I am not sure we can call this a "problem" with Lazarus. It is just that FPC and Lazarus uses UTF-8 strings by default on all operating systems.
by bobo
20.05.2011, 19:30
Forum: ZeosLib 7.0 Beta Forum
Topic: 7.0 SVN MySQL calculated field content is returned as ??
Replies: 4
Views: 753

I just replaced the real field names I have in my example, so that is not the problem.
Plus, as I've mentioned I use MySQL server.
And, as I've mentioned it works properly with 6.6.6 stable.
by bobo
20.05.2011, 03:30
Forum: ZeosLib 7.0 Beta Forum
Topic: 7.0 SVN MySQL calculated field content is returned as ??
Replies: 4
Views: 753

7.0 SVN MySQL calculated field content is returned as ??

The following SQL statement executed on a MySQL 5.x table with TZQuery SELECT DATE_FORMAT( CTime, '%Y/%m/%d' ) AS FClicked, count( * ) AS Cnt FROM TableName GROUP BY FClicked ORDER BY FClicked the field value of the result set field "FClicked" always returns '??' instead of the date values...