[REQ,HELP] Retrive strings from an sql base into a plugin - Page 2

Exolent[jNr] · 03-08-2012 , 16:26 Re: [REQ,HELP] Retrive strings from an sql base into a plugin

Try this:

If you already have the table created, perform this query in the database:
ALTER TABLE ad_manager MODIFY advertisement VARCHAR(512) CHARACTER SET utf8 COLLATE utf8_bin;

Swear · 03-08-2012 , 16:38 Re: [REQ,HELP] Retrive strings from an sql base into a plugin

I mean database is okay, it displays and stores utf-8 symbols as it should, but ad_manager displays only ? marks where unicode symbols should be. I guess it uses SET NAMES latin1 by default, so it needs set names utf8 query, before selecting data.

GuskiS · 11-01-2013 , 09:21 Re: [REQ,HELP] Retrive strings from an sql base into a plugin

Can someone fix this? In database it's all ok, but when it comes to printing, it shows ? where UTF8 special symbols are.

pupil0888 · 11-12-2014 , 20:47 Re: [REQ,HELP] Retrive strings from an sql base into a plugin

as I get to run this plugin ad_manager_sql for multiple servers? where should I place the messages? that host must create the table?

VINAGHOST · 08-03-2019 , 06:48 Re: [REQ,HELP] Retrive strings from an sql base into a plugin

sorry for reviving the post

When plugin show in the screen it replaces Unicode character to ?
But in the database, it's okay.

Can anyone help me?