I have a MySQL database using UCS2_UNICODE_CI collation. I connect to it via Zeos 7.1.3a, within Delphi XE2 (x32)
Zeos is configured:
ClientCodePage := 'UTF8';
ControlsCodePage := cCP_UTF16;
AutoEncodingStrings := True;
etc...
I have no issues when I post/retrieve Text data from a blob field, I can post using the fieldname.ASSTRING and I retrieve in the select query via (Select (convert fieldname using UTF8) as ...), but if I post to a TEXT field, when I select the text within it, many of the characters are displayed with question marks (?).
Is there a way I can post / query TEXT fields to mimic the same behavior I get with BLOB fields?
Saving/Retrieving Text from MySQL TEXT field
The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
Return to “ZeosLib 7.1 stable Forum”
Jump to
- Links
- ↳ Bugtracker
- ↳ Downloads
- ↳ Subversion
- ↳ GitHub
- ZEOS Library - General
- ↳ Announcements
- ↳ Downloads
- ↳ Documentations
- ↳ Tutorials
- ↳ ZDBC (ZEOS Database Connectivity)
- ↳ User Contributions
- ↳ Feature Requests
- ↳ User Patches
- ZEOS DBO v8.x
- ↳ ZeosLib 7.3/8.0 Forum
- ZEOS DBO v7.x
- ↳ ZeosLib 7.2 Forum
- ↳ ZeosLib 7.1 stable Forum
- ↳ ZeosLib 7.0 Stable Forum
- ↳ ZeosLib 7.0 Beta Forum
- SQL Servers and Databases
- ↳ ADO
- ↳ DB2
- ↳ Firebird
- ↳ Interbase
- ↳ MS SQL Server
- ↳ MySQL
- ↳ Oracle
- ↳ OleDB (Microsoft Windows)
- ↳ ODBC
- ↳ PostgreSQL
- ↳ SQLite
- ↳ Sybase ASE
- Compiler related
- ↳ CBuilder / C++
- ↳ Lazarus / Freepascal
- ZEOS DBO V 6.x
- ↳ 6.6 - stable
- ↳ 6.5.1 (alpha) - 6.6.x (beta)
- ↳ 6.1.5
- ↳ Other 6.x Versions
- ↳ Bug Reports
- ZEOS DBO V 5.x
- ↳ 5.x Versions
- Software projects using ZeosLib
- ↳ SQLite Administrator
- Other and Non-Technical
- ↳ Off Topic