[SOLVED] [SQL] problem with specific caracter

Razmo51 · **Author**

Hello,

I'm looking to insert some data in SQL,

my .sp is encoded in ut8 without BOM,
my database is encoded in utf8_generals_ci, and it don't work.

Can anyone help me ?

delachambre · 07-09-2012 , 11:56 Re: [SQL] problem with specific caracter

Problem on insert a pseudo of player's in DB ?

unt0uch4bl3 · 07-09-2012 , 12:07 Re: [SQL] problem with specific caracter

If you are using MYSQL, you may need to execute this query after connecting to the database:

Code:

FormatEx(query, sizeof(query), "SET NAMES \"UTF8\"");

Razmo51 · *Last edited by Razmo51; 07-09-2012 at 12:26.*

PHP Code:


			
 new String:g_charset[600];
        Format(g_charset, sizeof(g_charset), "SET NAMES 'utf8'");
        
        SQL_FastQuery(g_hBdd, g_charset);
        
        new String:g_insertquery[600];
        Format(g_insertquery, sizeof(g_insertquery), "INSERT INTO `logs_web_full` (`prefix` ,`heure` ,`joueur` ,`cmd`) VALUES ('%s',  '%s', '%s', '%s')", prefix, Time, id,cmd);
        
        SQL_FastQuery(g_hBdd, g_insertquery);

when I print my queries, specific caracter are good, but in the SQL, the result are bad

(I use MYSQL)

EDIT: fixed