URGENT: Collation problems with Greek text
Posted by: Manos Krokos
Date: November 11, 2006 09:09PM

I hate to double-post, but I just saw that this forum is more appropriate...

Hi,

I just upgraded from mySQL 4.x to 5.x and I am running into some serious problems.

I was planning to make all of my scripts utf-8 compatible, so I made a backup of them, I created an SQL dump for each DB and althered the ones that were not utf-8.

So, I end up with a full set of sql dumps, one for each one of my db's and they are all utf-8 encoded. so far so good, i guess.

I upgrade and I see that the default collation is "latin1_swedish_ci" for some reason. Which brings us to my first question:

1. How can I change the default variables? I am going to be working with a mixture of Greek and Latin so, I would think that "utf8_general_ci" would be the ideal. And what other variables need to be changed?

2. Most of my scripts don't work anymore. Well, they do but instead of greek text I get lots of questionmarks. The encoding used in the php pages is "utf-8" and the tables and DB's are created using "utf8_general_ci". If I use phpMyAdmin to browse the contents of one of these DB's I see the text just fine. But when the text is called in the php scripts, all I get is a series of questionmarks.
What is really strange is that if i correct the data in some php form or another, then the result looks OK on the page but the DB text is now messed up!!
Is there another factor that I have not looked into?

Please, help me as this is extremely urgent! The only other solution I can think of is to restore the full backup of my server and don't think about upgrading unless I figure this out.

Manos K



Edited 1 time(s). Last edit at 11/11/2006 09:09PM by scud.

Options: ReplyQuote


Subject
Views
Written By
Posted
URGENT: Collation problems with Greek text
2525
November 11, 2006 09:09PM


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.