UTF8 encoding

[flori]

Dear friends!

I have a little program which use ZConnection, ZQuery, datasource, ZUpdate, etc. Database: Firebird 2.5. When we try to upload special characters for example: ű, ő, ű, etc we get the ''MaghÃvelyes'' mixed letters.
 
I set ZConnection ControlscCodePage:  cCP_UTF8.
 
Any help would greatly be appreciated.
Many Thanks,
Florian

[balazsszekely]

Did you set the appropriate charset(UTF8) for each varchar field in the table?

[flori]

yes.
 I use IBexpert. After database registration I set charset UTF8 and I try to set ZConnection properties:
codepage=
controls_cp=CP_UTF8

but still i get mixed characters....

[balazsszekely]

I use IBexpert.

Good. Excellent program!

I set charset UTF8 and I try to set ZConnection properties:

Try the charset for the table, as in the attached image.

[flori]

yes i set UTF8 there. but still mixed.

[flori]

Try to write "hagyományos gyümölcsös alma"  i think you get mixed characters

[balazsszekely]

@flori
Please do the following:
1. Go to ZConnection --> Properties, then add the following: "codepage=UTF8" without the quote
2. Remove any other codepage settings from your code
3. Modify table charset with IBExpert
4. Add the following record: "hagyományos almából keszített minőségi pálinka"

This will work 100%.

[flori]

@GetMem
Yes I wrote ZConnection - properites codepage=UFT8 then changed with IBExpert and add "hagyományos almából keszített minőségi pálinka"
but I still get mixed.
I have attached sample programs.
When I try import excel to dbgrid I always get mixed characters. When I try without import but still not good. :S

please check if you know:
https://1drv.ms/f/s!AqVsnEe7He7Ngvx-f1SaPY7fnJMJqg

Many thanks

[flori]

So..
''hagyományos almából keszített minőségi pálinka'' work perfect but ''Hagyományos gyümölcsös kajszi'' not work :S
I do not understand

[balazsszekely]

@flori

It works fine here. Please attach another "tablak.xlsx" with more problematic names. Add at least 5-6 so I can test. Use the Attachments and other options, below this textbox.

PS: I modified your project, you use a lot of absolute path which is wrong.

[flori]

ok. Yes I use absolute path because this is the test project.

Problematic names:. https://1drv.ms/f/s!AqVsnEe7He7Ngv0A3EcnsORvrFHo-Q
 It does not work for me...

[balazsszekely]

Please test: https://drive.google.com/file/d/1tGYNK1iyCux4KUp-WUHnfys1kUExCQ94/view
The database, xlsx files are located in the data sub folder.

[flori]

ok. Thank you. But I get same problem...

[balazsszekely]

What is your Lazarus/FPC version?

[flori]

I use lazarus-1.8.2-fpc-3.0.4 and you?