UTF8 encoding

[balazsszekely]

Lazarus Trunk/FPC 3.0.4, but with 1.8.2 should work just fine.
Can you check something for me, add a showmessage here:

Code: Pascal  [Select][+][-]

1. //...
2.               ftDateTime,
3.               ftTime: ZQuery1.Fields[c].AsDateTime := datacell^.NumberValue;
4.               ftString: begin //here
5.                            ZQuery1.Fields[c].AsString := datacell^.UTF8StringValue;
6.                            ShowMessage(datacell^.UTF8StringValue);
7.                         end;
8.             end;
9. //...

What do you see when you press the import button?

[flori]

msgbox show normal character

[balazsszekely]

OK. Then zeos is the culprit. What is your Zeos version, I use 7.1

PS: Can somebody please test the project from reply #11 ?

[flori]

I use zeos 7.0

[balazsszekely]

You can run a few test with 7.1. it's worth a try.

[flori]

sorry I use zeosdbo-7.2.4-stable.

can you send your version?

[flori]

https://sourceforge.net/projects/zeoslib/files/Zeos%20Database%20Objects/zeosdbo-7.1.1-rc/   this is good?

[balazsszekely]

You can install it via OPM(http://wiki.freepascal.org/Online_Package_Manager).  Just uninstall 7.2.4 before and rename the old directory just to be sure.

[flori]

Yes just work
THANK YOUUUU!!!!!!!!!!!!!
I am very grateful
I have a small program which used ZConnection 7.2.4. Just I installed 7.0. I can change just ZConnection or ZConnection and all ZQuery, etc? What is your opinion? I have to replace every component or just ZConnection?
Thank u.

[balazsszekely]

Yes just work
THANK YOUUUU!!!!!!!!!!!!!

Cool! I'm glad it works.

What is your opinion? I have to replace every component or just ZConnection?

If you can open/build your project, you don't have to replace anything.

[flori]

@GetMem! HELP!

I changed IBXexpert charset UTF8. When I tried to import mixed characters I get this... Dynamic SQL ErrorSQL error code = -303 - string right truncation.
Im enclosing.
I set ZConnection this:
codepage=UTF8
controls_cp=CP_UTF8

.. and installed 7.1.1
Do u know why am I get this error...?
Thank you

[balazsszekely]

Please read this: http://www.firebirdfaq.org/faq79/
Possible causes:
1. The field(varchar) is too short. You need to increase column size
2. You're mixing different character set. Work only with UTF8 on both sides

[Thaddy]

And
3. Because an UTF8char can be 4 times the size of a (Ansi)Char, the field must also be 4 times the size you may expect because of that.

[Zoran]

And
3. Because an UTF8char can be 4 times the size of a (Ansi)Char, the field must also be 4 times the size you may expect because of that.

In Firebird, if the field is declared with codepage utf8 (and it is automatically, if the default character set for the database was set to utf8 before the table creation), the actual size is adjusted behind the scene (to be 4 times declared size, actually), it is not something you need to worry about.

To be sure of that, execute this (replace the table name in the last line):

Code: SQL  [Select][+][-]

1. SELECT rf.rdb$relation_name, rf.rdb$field_name, cs.rdb$character_set_name,
2.   f.rdb$character_length, f.rdb$field_length, cs.rdb$bytes_per_character
3. FROM rdb$fields f
4. INNER JOIN rdb$relation_fields rf ON rf.rdb$field_source = f.rdb$field_name
5. INNER JOIN rdb$character_sets cs ON cs.rdb$character_set_id = f.rdb$character_set_id
6. WHERE rf.rdb$relation_name = 'TABLE1' /* replace with your table name */
7.  

You will get a list of the varchar and char fields from the table you want.
Now, examine the results:
  - is rdb$character_set_name for all fields "UTF8"?
  - compare the values of rdb$character_length and rdb$field_length.

[flori]

Im enclosing my fdb file. I set UTF8, but not working at special characters.
The special characters include GAZDALKODAS2 table.