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

CONSOLE_APP_MAIN
{
  String s = "SELECT nombre, refcontable FROM actividades_clases" ; 

  MySqlSession sesion ;
  if (sesion.Connect( "root", "mundoflipi", "skorg_dsrllo_v3", "localhost" ))
  {
    Sql q(sesion) ;
    q.Execute(theSelect) ;
    int row = 0;	
    while(q.Fetch())
    {
      String resp =   ;
      Cout() << "[" << row << "] " << resp << (String)q[0] << "  " << (String)q[1] << "\r\n" ;
      row++ ;
     }
     sesion.Close() ;
   }
}

CREATE TABLE `actividades_clases` (
  `code` varchar(22) collate utf8_spanish_ci NOT NULL default '',
  `nombre` varchar(30) collate utf8_spanish_ci default NULL,
  `dAdmin` varchar(2) collate utf8_spanish_ci default NULL,
  `isVentas` int(11) default NULL,
  `refContable` varchar(30) collate utf8_spanish_ci default NULL,
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
INSERT INTO `actividades_clases` VALUES  ('0070000000000002','NICOLÁS','D',0,'DHARMA'),
 ('0070000000000003','cúlturá','F',0,'CULTURAL'),
 ('0070000000000004','DOCENCIA','F',0,'DOCENCIA'),
 ('0070000000000005','VOLUNTARIADO','?F',0,'VOLUNTARIADO'),
 ('0070000000000006','RESIDENCIA','?F',0,'CONVIVENCIA'),
 ('0070000000000007','COMEDOR','?F',0,'CONVIVENCIA'),
 ('0706401e1a6607402b3500','VENTAS','F',1,'VENTAS FUNDACIÓN'),
 ('0706401e10216c0f1c6100','ARTICULOS DEL REFUGIO','F',1,'REFUGIO');

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

    Sql q(sesion) ;
    q.Execute(theSelect) ;

String sysCharSetName = CharsetName(GetDefaultCharset());

#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() ;
   }
}