thanks, i depply test it, and conclusion is
i dont need SET NAMES
when i use ClientCodePageOptions = cp1250 ZQuery shows bad characters
whe i use ClientCodePageOptions = utf8 ALL is WORKING fine
for other rededers, don't forget set coSetCodePageToConnection to true
so thank you
Search found 7 matches
- 21.03.2012, 11:20
- Forum: ZeosLib 7.0 Beta Forum
- Topic: [patch_done] ZROQuery show czech characters OK, ZQuery don't
- Replies: 3
- Views: 595
- 20.03.2012, 14:04
- Forum: ZeosLib 7.0 Beta Forum
- Topic: [patch_done] ZROQuery show czech characters OK, ZQuery don't
- Replies: 3
- Views: 595
[patch_done] ZROQuery show czech characters OK, ZQuery don't
hi, in my app differs output from ZReadOnlyQuery and ZQuery, i use Delphi XE and i try zeoslib 667, v7 v8 v9 and today new branch from EgonHugeist (thanks for your great work !) i try to uncomment WITH_CLIENT_CODE_PAGE_OPTIONS, i try to study http://zeos.firmos.at/viewtopic.php?t=3427 but nothing he...
- 29.09.2011, 13:02
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Tokenizer EConvertError - DateTime
- Replies: 3
- Views: 931
- 12.09.2011, 13:06
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Tokenizer EConvertError - DateTime
- Replies: 3
- Views: 931
Tokenizer EConvertError - DateTime
hi, i am using Delphi 7 lite on Windows 7 with MySQL 5.1.41 when i use SQL statement like this DATE_FORMAT(test,"%H:%i:%s") AS test i get error EConvertError in IDE, in runtime is it OK i try to debug this strange thing, and i found ZGenericSqlToken.pas there is a method TZGenericSQLQuoteS...
- 17.07.2008, 08:16
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: how to handle exception if MySQL server does not respond ?
- Replies: 3
- Views: 1029
i am sorry, its little weird, i create litle app with this try connect except block, and everything works fine, but in my big application shows exception only in Delphi IDE in runtime shows UNKNOWN exception :( should i setupo something in delphi menu tools - debug options - OS Exceptions ? i'm usin...
- 16.07.2008, 20:09
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: how to handle exception if MySQL server does not respond ?
- Replies: 3
- Views: 1029
how to handle exception if MySQL server does not respond ?
hi, i try this code: function ConnectMySQL(iConexe: TZConnection; iIP: String; iDB : String): Boolean; begin Screen.Cursor := crSQLWait; ConnectMySQL := False; iConexe.HostName := iIP; iConexe.Database := iDB; try iConexe.Connect; ConnectMySQL := True; except on E:Exception do begin showMessage('Can...
- 29.06.2007, 12:57
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: TZQuery - wrong determining of parameters type ?
- Replies: 1
- Views: 610
TZQuery - wrong determining of parameters type ?
hi, i run some easy update query with parameters qu_insert_polozka_.parambyname('param_count').value := 1; so the DataType is now ftSmallInt in second call of my query qu_insert_polozka_.parambyname('param_count').value := 40000; the DataType remains and the execution of query causes an range check ...