Re: Produce XML with russian text



Bolla Sándor wrote:
...
I use DBExpress components and the text is stored in text's column in a 3.23.x MySQL version. To get back the data in Memo's and save them in the database there are no problems, only when I want to save them in an external file in an xml with utf-8 encoding.


Sounds like you need to consider the alternative solutions. DevExpress components are also not
Unicode Complaint at least until Delphi2008 is released.

So basically you are storing, retrieving and displaying the data in a Russian characterset. (Is your MySQL database also set to the same codepage characterset?) (I do not know MySQL database)
What does the text look like in the generated XML document. Does it show the Russian Cyrilic characters or some other characters? If you do not see the Cyrilic characters in the XML you need to make sure the text is properly encoded from what you see on the screen to the Russian equivalent letters to save in the XML.
When you convert to UTF8 characters you need to make sure the converter routine takes into consideration the Codepage characterset you are using when showing the text in the controls on the screen.

Siegfried
.



Relevant Pages

  • Re: Special Characters not resolving
    ... starting data at the origin in an ORacle database is 2000 characters. ... When the XML isdelivered to me on disk and I load an ... Obviously I need to find either a way to have the XML file provider strip ...
    (microsoft.public.dotnet.xml)
  • uploading image to mysql table
    ... I haven't found anything covering uploading to a ... MySQL database with .net. ... has to do with special characters in the image data. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: HELP: from XML to mySQL
    ... Yes I need to have the database in mySQL server. ... so why XML? ... So how store datas in clients program? ...
    (comp.lang.perl.misc)
  • Re: Help....How to set FreeBSD to handle UTF8 characters?
    ... I am running MySQL, Apache on freebsd server. ... I am unable to type the scandinavian characters even I have tried to ... I have a database in utf encoding. ...
    (freebsd-questions)
  • Re: Databases, Typed Datasets, and Flat Files oh my!
    ... file, get the right characters, and then manually add the rows to the ... This standard consists of a fixed ... dataset gets shoved into database (or vicea ... All of the stuff I see for typed datasets is "XML! ...
    (microsoft.public.dotnet.languages.vb)