U++ forum: Welcome to the forum

Re: Sticky problem : MySql and UTF8 [message #35239 is a reply to message #35231]

Tue, 24 January 2012 21:47

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

I use SQL schema added value:


//==================================================================================//
//==============================����� SQL ������===================================//
//==================================================================================//

#ifdef MYSQL_DB
#define SERIAL_ INT_
#endif 

//======================================================================================//
//											//
//					TERMINAL					//
//											//
//======================================================================================//

TABLE_ (TERMINAL)
#ifdef MYSQL_DB
	TABLE_SUFFIX("CHARACTER SET utf8 COLLATE utf8_general_ci\n")    // <<-----this line set right MySQL options
#endif  
 	SERIAL_	(TER_ID)  PRIMARY_KEY AUTO_INCREMENT
	STRING_	(TER_NAME,13)
	DATE_	(TER_DATECREATE)
	DATE_	(TER_DATEMODIFY)
	INT_	(TER_ID_GROUP)
	INT_	(TER_ID_TYPE)
	INT_	(TER_ID_TEMPLATE)
	INT_	(TER_PLACE)
	STRING_	(TER_COMMENT,255)
END_TABLE

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

[Updated on: Tue, 24 January 2012 22:04]

Report message to a moderator