charset incompatible
Posted by: Pedro
Date: May 26, 2006 07:03PM

I have this database that i want to move to other server

i dumped it to a .sql file, i can open it with any text reader like notepad++ ( windows ) and evey character looks ok...
the database is in portuguese and so some are special characteres... they all look ok, but when i upload the file to the server those chars get al messed up.

i edited the file with pico and there they are.. all messed up...

i try upload via ftp using binary mode... but it didnt solve anything...

any ideas on how to fix this?

the file is too big to load on phpmyadmin
Both databases have the same charset...
i can insert inser special charaters through the web forms of my script and they get inserted and displayed without troubles...

Edited 1 time(s). Last edit at 05/26/2006 07:03PM by Pedro .

Options: ReplyQuote

Written By
charset incompatible
May 26, 2006 07:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.