Raised This Month: $ Target: $400
 0% 

[SQL] Problem


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Had3s99
Member
Join Date: Sep 2015
Location: France
Old 06-28-2019 , 04:57   [SQL] Problem
Reply With Quote #1

Hello,

I've problem about charset sql with my plugin, when there is username with special character like this : "��������������", i've problem when i insert or update my record..

I've do that : db.SetCharset("utf8"); or db.SetCharset("utf8mb4");

Because utf8 can't supported this character and so i've record like that : "•Œ•Ÿ•œ•ŸŸ˜••Ÿ"

So if u can help me that can be cool !
__________________

Last edited by Had3s99; 06-28-2019 at 05:02.
Had3s99 is offline
CrazyHackGUT
AlliedModders Donor
Join Date: Feb 2016
Location: Izhevsk, Russia
Old 06-28-2019 , 13:49   Re: [SQL] Problem
Reply With Quote #2

When driver lost connection to MySQL server and tries to reconnect, he "loses" changed charset.
Try change charset always before any query.

Also UTF8MB4 supports only in SM 1.10 now.
__________________
My english is very bad. I am live in Russia. Learning english language - very hard task for me...

Last edited by CrazyHackGUT; 06-28-2019 at 13:49.
CrazyHackGUT is offline
Send a message via ICQ to CrazyHackGUT Send a message via Skype™ to CrazyHackGUT
Had3s99
Member
Join Date: Sep 2015
Location: France
Old 06-29-2019 , 12:01   Re: [SQL] Problem
Reply With Quote #3

Quote:
Originally Posted by CrazyHackGUT View Post
When driver lost connection to MySQL server and tries to reconnect, he "loses" changed charset.
Try change charset always before any query.

Also UTF8MB4 supports only in SM 1.10 now.
I've try to test to change before query, i've so compiled with include 1.10, i've try this
__________________
Had3s99 is offline
Had3s99
Member
Join Date: Sep 2015
Location: France
Old 06-30-2019 , 08:48   Re: [SQL] Problem
Reply With Quote #4

So i need build 1.10, but build 1.10 isn't compatible with ptah or dhooks no?
__________________
Had3s99 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 18:53.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode