Hello everyone,
I know Lazarus itself is UTF8 and ZeosLIB to is UTF8 , my first problem was I was loosing characters when sending to sql for example
čćšđ would become ccsd .
Controls codepage for ZeosLIB was CCP_UTF8 , with autoencodestring turned on. Then I've tried to used CCP_UTF16 (which is as far as I understood
Unicode, or is supposed to be ) , but it still did not work, I've got ? marks.
So I finally found the solution by mistake :
cGET_ACP ( I read somewhere it's ANSI ) , and AutoEncodeString is turned OFF . Now in Lazarus I see characters displaying normally , and even my queries work, and stored procedures don't complain. But in SQL the names display strangely ( I can live with it , if it won't be a bigger problem later )
For example :
Bad Wünnenberg - Bad Wünnenberg
Gütersloh - Gütersloh
Hövelhof - Hövelhof
I only plan to use Lazarus with this SQL database nothing else , I am planning to try it out from a Windows 2000 professional maschine , to see if the characters are displayed correctly.... then from a Hungarian Windows XP machine as well. On Windows 7 all is fine.
Any ideas for possible dangers I might be facing in the future because of this?
Greetings
Robert
UPDATE 08:21 20.05.2014
I did try it under Windows XP Professional, it to is Unicode and plain English it was (my Win7 is german) . I've went around characters displayed correctly...I've added a few
new MileageLog's they to were with Unicode characters..and it displays correctly on both WinXP and Windows 7 , so I guess, I can be safe as far as I use Lazarus + ZeosLIB... probably I would have a hell of a time if I would try to view this from Delphi...
UPDATE 22.05.2014
If I set it to CP_UTF16 , it inserts correct characters into SQL, with select I get back every character correctly... but the same characters from within lazarus are not visible
Lazarus 1.2.2 + ZeosLIB 7.1.3 + MS SQL 2008 r2
The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
-
- Fresh Boarder
- Posts: 2
- Joined: 21.05.2014, 19:36
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