I am having an issue using Lazarus + zeos + access in some characters (Ç, ~, í ... )
The problem is a bit weird, sometimes i can insert properly, but sometimes the characters go crazy, example:
When I am typing it is ok, the ç and ã
BUT when I exit the DBedit:
This happens sometimes, and sometimes the chars are registered just fine
Using zeos, with zeosconnection. ClientCodepage UTF8 / ControlsCodepage UTF8 / AutoEncodestrings true.
Tried to change the charset but the problem persists, and the worst thing is that sometimes it works but sometimes it seems to loose the charset...
This difference in behaviour occurs in the same run of the program. For example, I am typing, when I save a change to a record in my database, everything is fine and ok; then I try to create a new record and the problems occurs, and the funny thing is: when I type "requisição" the chars stay the same, but I proceed to type "requisição de saída" the chars break; it seen like a problem that the software is trying to auto-encode based on what I am typing.
Also, I have discovered that if I put an extra blank space after the word that has "...ção" in the end everything works as it should "requisição[][]de saída" where the [] are the two blank spaces
Any advice?