#include <Core/Core.h>
#include <MySql/MySql.h>

CONSOLE_APP_MAIN
{
  // GetDefaultCharset() ; allways returns CHARSET_UTF8 in my pc
  // If I want to change the codification I must make it in TheIDE and in addition establish 
  // it by hand to see if the result is correct.
  //SetDefaultCharset(CHARSET_ISO8859_15) ;
  // if you uncomment this line, you must change in the ide the default char set, and then
  // the result is ok


  int charSet = GetDefaultCharset() ;
  Cout() << "charset:" <<CharsetName( charSet )  << "\n" ;
  String 	s = "SELECT nombre, refcontable FROM actividades_clases" ; 

  MySqlSession sesion ;
  if (sesion.Connect( "root", "mundoflipi", "skorg_dsrllo_v3", "localhost" ))
  {
    mysql_set_character_set( sesion, "utf8") ;

    Sql q(sesion) ;
    q.Execute(s) ;
    int row = 0;	
    while(q.Fetch())
    {
	String f0 = ToCharset(charSet, (String)q[0], CHARSET_UTF8, '?') ;
	String f1 = ToCharset(charSet, (String)q[1], CHARSET_UTF8, '?') ;
			
	Cout() << "[" << row << "  source]" << (String)q[0] << "  " << (String)q[1] << "\r\n" ;
	Cout() << "[" << row << " encoded]" << f0 << "  " << f1 << "\r\n" ;
	row++ ;
     }
     sesion.Close() ;
   }
}