RAD Stidio 10 ODAC Export XMLTYPE Russian characters

edited November 2018 in FastReport VCL 5
I'm having several problems here that's been keeping me angry for a few days already. I've tried different solutions but none work for me. I'm using RAD Studio 10, ODAC 9.7 and FastReport 5.4.8, Oracle version 11.2.0.4.

1. Saving the *.fr3 into Oracle blob or clob through ODAC has a strange behaviour with russian symbols and chars like ' and " in tye dataset node of the FastReport xml. When I save my report into a TMemoryStream or a TStringStream it saves the data in some unknown charset, but the xml encoding says it's utf-8. Indeed TEncoding. UTF8 decodes the russian characters. Still the data goes incorrectly into the Oracle's DB field, either blob or clob. But upon importing the data back it comes okay from blob, but broken russian chars from clob. I use TfrxReport.SaveToStream and LoadFromStream methods. The ODAC's ftOraBlob and ftOraClob field types in OraProcedure.Param.LoadFromStream and SaveToStream.

2. As the report is held incorrectly in the database I can't work with XMLTYPE, since every charset I try breaks the russian characters and the sql text in the datasets within the FastReport xml file. The Select "CreateName" from Names where CreateName like '%%' changes in " to " and ' to ' and also the #13 break and become some strange symbols.

Does anyone have a FastReport to and from Oracle example with russian, datasets and dialog forms?

Comments

  • PolomintPolomint Australia
    edited December 2018
    I hope this doesn't sound patronising!

    But have tried breaking your problem down into smaller / more constrained parts?

    When we had a problem with inconsistent handling of currency symbols a while back, we found the problem was in one place with Charset set to (if I remember correctly) ANSI. If you search these forums for "rupee" you'll find that discussion.

    Creating a number of models, and isolating the variables, always works for me.

    Cheers, Paul

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.