I do not remember how the tables were transferred from the old DB to the new (more likely through a mysqldump).
The end effect was that the tables in the 4.1 MySql Db had a collation of latin1_swedish_ci.
After backing up the affected tables, do:
Just make sure you return the column type at exactly what was before you made it a blob.
Now the columns should have a collation of greek_general_ci
Furthermore, in case the php scripts gives you trouble loading the new rows, try something like:
The above example was run in some AdoDB Phakt scripts, but the gist of it is before any selects run the above sql commands.
Good luck...
The end effect was that the tables in the 4.1 MySql Db had a collation of latin1_swedish_ci.
After backing up the affected tables, do:
Just make sure you return the column type at exactly what was before you made it a blob.
Now the columns should have a collation of greek_general_ci
Furthermore, in case the php scripts gives you trouble loading the new rows, try something like:
The above example was run in some AdoDB Phakt scripts, but the gist of it is before any selects run the above sql commands.
Good luck...
