U++ forum: Welcome to the forum

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

Thu, 19 April 2012 18:47

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

Contributor

sergeynikitin wrote on Tue, 24 January 2012 23:47

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

Some improvements:

#ifndef flagPGSQL_DB
#define SERIAL_ INT_
#else
#define AUTO_INCREMENT	
#endif

#ifdef flagMYSQL_DB
#undef TABLE_
#define TABLE_(x)	DOID(x) TABLE(x) \
	TABLE_SUFFIX("CHARACTER SET utf8 COLLATE utf8_general_ci\n")
#endif

//======================================================================================//
//											//
//					    USER					//
//											//
//======================================================================================//

TABLE_ (USER)
	SERIAL_	(USR_ID) PRIMARY_KEY AUTO_INCREMENT
	STRING_ (USR_NAME, 255)
	STRING_ (USR_REALNAME, 255)
	STRING_ (USR_LOGINNAME, 20)
	STRING_ (USR_PASSWORD, 20)
	STRING_ (USR_RIGHTS, 2000)
END_TABLE

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

[Updated on: Thu, 19 April 2012 18:51]

Report message to a moderator