News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

UTF-8 Conversion

Started by JayBachatero, January 08, 2007, 09:39:10 PM

Previous topic - Next topic

mymktp1

Hi I currently am having the same problem as many other people have been having and was wondering if anyone could help me... I have a phpBB forum in THAI language  which I checked in mySql that the Collation is all in Latin-1 which should be in UTF-8 ... and I don't know and kind of hesitated to change this since I don't really know what I'm doing... I have successfully converted phpbb to smf...  but the characters don't come out right at all... and I'm thinking collation set in my phpBB is probably the problem... can anyone help me with this?

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!


mobilewo

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'mobilewo'@'WEB10' for table 'phpbb_users'

ThorstenE

Quote from: mobilewo on July 10, 2008, 05:41:08 AM
The error MySQL gave was: SELECT command denied to user 'mobilewo'@'WEB10' for table 'phpbb_users'
Common conversion errors

fiolek

Hi,
I am new here and I am trying to convert my nuke forum to smf, but I still have ? instead of polish letters. I tried to change collation to latin1, latin2, utf8 I to convert nuke db to utf but i still have te same problem, can anyone help me with this?

Sarge

Quote from: fiolek on July 24, 2008, 06:18:08 PM
Hi,
I am new here and I am trying to convert my nuke forum to smf, but I still have ? instead of polish letters. I tried to change collation to latin1, latin2, utf8 I to convert nuke db to utf but i still have te same problem, can anyone help me with this?

1) Can you tell us what collations are used in the original database (for both the forum tables and table columns), and what did you do (step by step)?

2) Follow the steps in reply #53, but replace:

mysql_query("SET NAMES $db_character_set");

with:

mysql_query("SET NAMES latin2 COLLATE latin2_polish_ci");


If that doesn't work, try:

mysql_query("SET CHARACTER SET latin2 COLLATE latin2_polish_ci");


    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

fiolek

I've got:
character set client     utf8
(Wartość globalna)    latin1
character set connection    utf8
(Wartość globalna)    latin1
character set database    latin1
character set results    utf8
(Wartość globalna)    latin1
character set server    latin1
character set system    utf8
character sets dir    /usr/share/mysql/charsets/
collation connection    utf8_general_ci
(Wartość globalna)    latin1_swedish_ci
collation database    latin1_swedish_ci
collation server    latin1_swedish_ci

in db with nuke I have latin2 (i tried also utf8)

Step by step I tried eg instruction from this topic

Quotemysql_query("SET NAMES $db_character_set");
but in nuke converter I haven't it

Sarge

Quote from: fiolek on July 25, 2008, 05:06:49 AM
Quotemysql_query("SET NAMES $db_character_set");
but in nuke converter I haven't it

Get the latest convert.php and find this:

mysql_query("SET NAMES $charset");


(Apparently, $db_character_set has been replaced with $charset in recent versions.)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

fiolek

But it still doesn't work. What collation i db should I use?

Sarge

Quote from: fiolek on July 25, 2008, 05:06:49 AM
I've got:
in db with nuke I have latin2 (i tried also utf8)

What collation are the tables and the table columns?

What is the page encoding in your browser? (View > Character Encoding in Firefox, View > Encoding in IE)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

fiolek

Latin2 but I convert i tried also on utf8.
In my browser it is iso

Sarge

Quote from: fiolek on July 25, 2008, 06:36:28 AM
Latin2 but I convert i tried also on utf8.
In my browser it is iso

What latin2 collation? latin2_general_ci, latin2_croatian_ci, or what?
What ISO encoding is autoselected in your browser? ISO-8859-1, -2, or what?

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

fiolek

latin2_general_ci and iso 8859-1

Sarge

If you change the page encoding to ISO-8859-1 or ISO-8859-2 for your SMF forum pages from the browser, do the Polish characters show up correctly?

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

fiolek

No, i've got also ? instead of polish signs in my db

Kvark

May I ask some help? My phpBB was gone (phpMy Admin don see it) but converter from phpBB to SMF read folder of phpBB instalations place and some how get data back, but its in utf maybe becouse i install SMF in 1251 charset, and i dont remember wich cahrset was in BB also is it posible some how insert post into SMF but dont loose 1251 charset? 

Sarge

Quote from: fiolek on July 25, 2008, 07:14:55 AM
No, i've got also ? instead of polish signs in my db

Link to your forum? Feel free to send it via PM if you don't want to make it public.

If you want to give me access, I can try doing the conversion myself.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Sarge

Quote from: Kvark on July 25, 2008, 08:46:16 AM
May I ask some help? My phpBB was gone (phpMy Admin don see it) but converter from phpBB to SMF read folder of phpBB instalations place and some how get data back, but its in utf maybe becouse i install SMF in 1251 charset, and i dont remember wich cahrset was in BB also is it posible some how insert post into SMF but dont loose 1251 charset?

If phpMyAdmin cannot see the DB but the converter can, something is wrong there. Contact your host about it.

UTF-8 supports cp1251 characters, you just have to convert them to UTF-8 format. But without knowing what exactly the original character set is, results can be unpredictable.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

nackgr

#79
i have a vb 3.8.1  with latin1 swedish_ci collation  forum is at greek lang  to view it  i use iso 8859-7 and i want to convert it  to  smf 


i convert it  but  characters are  #%@#!2$ what should i do ?
i cant connect to admin panel  bcause users dont work ... it says wrong password
Forumakias.gr για να περνάμε καλα ..

Advertisement: