#1 2009-11-23 12:06 am

MOB

Member

Registered: 2009-11-22

Posts: 15

Character Set for phpbb_bans.sql??

Hi,

I need to know what is the Character Set for the phpbb_bans.sql file.  Because when I import it to my database, mostly all the special characters will show up as just "question marks".  See example below:

Äÿòëîâ = ?????

Thanks in advance.

pedigree

uıɐbɐ ʎɐqǝ ɯoɹɟ pɹɐoqʎǝʞ ɐ buıʎnq ɹǝʌǝu ɯ,ı

From: New Zealand

Registered: 2008-04-16

Posts: 7,104

Re: Character Set for phpbb_bans.sql??

Thats a good point you know, Ill have a look

MOB

Member

Registered: 2009-11-22

Posts: 15

Re: Character Set for phpbb_bans.sql??

Thanks, I would really appreciate you finding out for me.

Just finished doing some tests.  What I did was just create a small test.sql file by just including those with special characters that weren't generating correctly on my site.  What I found out, is that character setting "latin1" seems to be the one that correctly inserts those special characters.  I had to empty the tables (in question) a few times and test each character set, until I stopped seeing a bunch of question marks [??????].  FYI, the first character setting I was using that would generate the problem was "UTF8"

But I hope it helps others, but at the same time, I am looking forward to what you find out.  Thanks in advance.