U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Sticky problem : MySql and UTF8

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: Sticky problem : MySql and UTF8 [message #35224 is a reply to message #35044]

Mon, 23 January 2012 22:37

BioBytes is currently offline

BioBytes
Messages: 307
Registered: October 2008
Location: France

Senior Member

Right way to solve the accentuated issue with MySql and UTF8 is to add the following code after getting the connection:

mysql_set_character_set(MySession,"utf8");

Operations of insertion must be done as follows:

String str = ToCharset(CHARSET_UTF8,AsString(~MyEditString),GetDefaultCha rset(),'?');
SQL &Insert(MYTABLE)(NAME,str)(NUM,MyEditInt.GetData());

Operations of deletion must ne done as follows:

SQL &Delete(MYTABLE).Where(NAME==ToCharset CHARSET_UTF8,~MyEditString,GetDefaultCharset(),'?'));

I will try to post a code snippet to explain in details how to proceed with MySql and UTF8 encoded tables.

Hoping this will be helpful for someones

Biobytes

Report message to a moderator

Send a private message to this user

[Message index]

		Sticky problem : MySql and UTF8 By: BioBytes on Mon, 02 January 2012 10:56
		Re: Sticky problem : MySql and UTF8 By: BioBytes on Mon, 23 January 2012 22:37
		Re: Sticky problem : MySql and UTF8 By: mirek on Thu, 26 January 2012 10:01
		Re: Sticky problem : MySql and UTF8 By: BioBytes on Sat, 28 January 2012 10:54
		Re: Sticky problem : MySql and UTF8 By: mirek on Sat, 04 February 2012 18:55
		Re: Sticky problem : MySql and UTF8 By: mr_ped on Tue, 24 January 2012 08:53
		Re: Sticky problem : MySql and UTF8 By: sergeynikitin on Tue, 24 January 2012 21:47
		Re: Sticky problem : MySql and UTF8 By: BioBytes on Wed, 25 January 2012 21:49
		Re: Sticky problem : MySql and UTF8 By: sergeynikitin on Thu, 19 April 2012 18:47
		Re: Sticky problem : MySql and UTF8 By: BioBytes on Fri, 20 April 2012 10:33

Previous Topic:	Added partial support for ODBC output parameters, but the solution is ugly
Next Topic:	MSSQL, default DB, datetime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Tue May 14 18:53:14 CEST 2024

Total time taken to generate the page: 0.02034 seconds