[Wizard4U]

Hello everybody from Croatia!
I have database in iso-8859-2, but I need to create xml file in utf-8.
Where and how to put set utf-8 in my code?
Thanks
I do like this in PHP

Code:

db_connect();
	mysql_query("SET NAMES 'UTF8'");
mysql_query("SET character_set_client='UTF8'");

This is my asp.net code for database connection

Code:

'CONNECTION TO DATABASE
			dim dbconn,sql,dbcomm
			dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=" & Server.MapPath("../baze/test.mdb"))


			dbconn.Open()
			

			sql="SELECT * FROM	nekretnine, tipovinekretnina WHERE nekretnine.idtipnekretnine = tipovinekretnina.idtipnekretnine ORDER BY nekretnine.idnekretnine"
			dbcomm=New OleDbCommand(sql,dbconn)
			dbread=dbcomm.ExecuteReader()
			
			while dbread.Read()

[Wizard4U]

Nobody know's, or nobody want's to tell me!
Can somebody PLEASE help me!

[omniman]

Presumably you will be using the System.Xml namespace - probably XmlWriter... I think you can set the encoding via that somehow but it is escaping me now.

[Wizard4U]

I heavent't hear for that method. I know that I must after conncection on access database do encoding from iso-8859-2 to utf-8 and then print or something else.

[omniman]

When you initialize the HtmlTextWriter, you can set the encoding there - that will setup the XML properly, then you just iterate your result set and write the nodes.

The following example is just static, but you could easily convert it to iterate your dataset and write dynamically. It's in C# so you may need to convert it but there are plenty of free converters online.

Also, you will probably need to convert it to write to the buffer rather than a file.

using System;
using System.IO;
using System.Xml;

public class Sample
{ 
  public static void Main()
  {
    XmlTextWriter writer = new XmlTextWriter("myMedia.xml", System.Text.Encoding.GetEncoding("utf-8"));

    //Use automatic indentation for readability.
    writer.Formatting = Formatting.Indented;
        
    //Write the root element
    writer.WriteStartElement("items");

    //Start an element
    writer.WriteStartElement("item");

    //Add an attribute to the previously created element 
    writer.WriteAttributeString("rating", "R");
     
    //add sub-elements
    writer.WriteElementString("title", "The Matrix");
    writer.WriteElementString("format", "DVD");

    //End the item element
    writer.WriteEndElement();  // end item
 
    //Write some white space between nodes
    writer.WriteWhitespace("\n");

    //Write a second element using raw string data
    writer.WriteRaw("<item>" + 
                    "<title>BloodWake</title>" +
                    "<format>XBox</format>" + 
                    "</item>");

    //Write a third element with formatting in the string
    writer.WriteRaw("\n  <item>\n" + 
                    "    <title>Unreal Tournament 2003</title>\n" +
                    "    <format>CD</format>\n" + 
                    "  </item>\n");

    // end the root element
    writer.WriteFullEndElement();
             
    //Write the XML to file and close the writer
    writer.Close();  
  }
}