How to preserve accents when uploading database tables?

[transgenik]

Hi all!

After having troubles with my PHPbb forums yesterday, I've decided on reinstalling everything from scratch and then re-upload every MySQL table manually. This wasn't done easily, but I managed.

My only problem is that on the SQL upload page, I've tried many encoding from the menu (set by default to UTF8), and everytime, I keep loosing accentuated characters. My users are all French-speaking, and this is a real problem for me (not that they're French speaking, but loosing the accents ;-))

Could anyone help me on this matter?

[YvetteKuhns]

Is it the database info that changed or the output to the web page that loses the French accent characters?

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

This line appears in your HTML output for French Unicode. Then the problem is your database.

http://www.sql-server-performance.com/vg_database_comparison_sp.asp
See item #7
You either have to support all collations or force your clients to reinstall SQL Server with the collation you chose. It is not quite clear why French data in French_CI_AS collation and Latin1_General_CI_AS collation are incompatible. All collation properties are the same:

There is more info about how to deal with this problem.

http://www.issociate.de/board/post/2862/Pb_with_the_French_accentuated_characters.html
Same problem, different database, more solutions

I am guessing that you have both English and French languages installed for your phpBB forum. You could manual replace words in the database with those typed with the characters appearing correctly, but that would take some time.

Did you try looking at http://www.phpbb.com/support/ for help? Hopefully, someone can give you a reasonable solution.

Good luck!

[transgenik]

Thanks for your answer. Finally, I copied and pasted manually each table instead of uploading them as text files, it seemed like the only way my accents would be preserved.

Some of the data went corrupt in the process, but I have at least the last 3 months of data intact, WITH special characters.

I feel sooooo tired now... I would have had so many other things to do 9 days before delivering a baby! :rolleyes:

[YvetteKuhns]

Finally, I copied and pasted manually each table instead of uploading them as text files, it seemed like the only way my accents would be preserved.

I suspected that would be the easiest, if not the most tedious way to do it.


I feel sooooo tired now... I would have had so many other things to do 9 days before delivering a baby!

I saw your timeline and that is your EXPECTED date. My son was nine days late. My twin sister and I were three weeks late! I think someone miscalculated my mother's due date. ;)

Looking forward to the final results for the baby and pictures! :)