Dizkus

Hello People! I have a little problem, I am copying the nuke_stories, nuke_stories_cat table from PN764 to a Openstar PN distribution. When I have copied the tables and I view the news module in the browser I have an encoding problem with some characters... for exaple, the word "estarán" appears like this: "estarán". Both tables (the original and the destiny) are latin1_swedish_c1. The only difference are that the PN764 use MYISAM tables and OpneStar use InnoDB, but i changed that and nothing happend :(

Any idea to resolve this problem??
Thanks a lot!!

Tomas :)

--
Tomás

Depending of how do you exported your PN764 tables, the SQL file can be 'corrupted (inconsistent encoding). Check you Openstar tables to see if the characters are good or not, check your SQL file... in that cases, i don't use the gzip export option in phpMyAdmin because sometimes it change the encodig (sure it must be a config parameter somewhere to prevent that but i don'w know where).

Tell us if you SQL file have a incosistent encoding.

--
- Mateo T. -
Mis principios... son mis fines

Is it the same phpMyAdmin distribution?

I Export always the SQL file and use the import function.
Make sure your character set is latin1 and you should be clear.

- Igor

--
Have a nice day

zikulapro.be is currently running
Zikula 1.0.2

Also very usefull
http://www.ozerov.de/bigdump.php

I always have succes important large files.
Again, in the config, set 'latin1'

- Igor

--
Have a nice day

zikulapro.be is currently running
Zikula 1.0.2

I'm using the "Operations" link of phpMyAdmin to copy de tables from one database to another (I'm copying Data and structure) and yes, the enconding of both DB is "latin1_swedish_c1" ... :/

I don't know what it's happening!
I use Firefox to view the website.. and If I change de text encoding in Firefox I can see well the characters... but that's no the original problem...

Any idea ?

Thanks!!!! ;)



I'm using phpMyAdmin 2.6.2-pl1



edited by: tlombardini, Oct 02, 2007 - 08:25 PM

--
Tomás