I need help with the conversion of the database, every time I add a link I have to edit the link and replace the punctuation one by one, at this point the site that is already 1 year old is staring to pick up but is really hard for me to edit every single link description and replace the letter to add it to the DB. This happened after you updated the database and the encoding was changed, for the last 6 months I've been editing every single link that is added but now I receive up to 20 links a day and is really hard to keep up, the site has now over 10,000 links, Please Brian or Mr Golovko I need help on this one, I will give you my password to the hosting company if necessary, I'm still using y ADP v1.3.7 and is working fine. The letters are in Spanish and the ñ as well as each vowel has to be replace for one without the punctuation or accent. I changed the encoding in the output so that the users can see the page without those characters. Thanks

PM me your info, I will take a look.

Everyone should verify that their table collation's are running on utf8_general_ci or utf8_bin for maximum compatibility with special characters not normally part of the US character-set.

EDIT:

Correction

utf8_general_ci or utf8_bin are fine for every language but are not a precise for special characters

utf8_unicode_ci is better if you are using special characters, i.e. letters with accents

Read more here: http://forums.mysql.com/read.php?103,18 ... msg-188748

Re: Password
Sent: 06/23/2010 8:26 am
by tonylama

I can't change it, I get this error
ALTER TABLE `links` CHANGE `title` `title` TEXT CHARACTER SET utf8 COLLATE utf8_spanish_ci NULL DEFAULT NULL

what was the collation that we had before the upgrade ? maybe I can look it up and someone had the same problem and fixed it.
Re: Password
Sent: 06/23/2010 8:02 am
by tonylama

I'm trying now, thanks.
Re: Password
Sent: 06/23/2010 5:47 am
by tonylama

Yes, now accepts the special characters but how about all those records that I entered before the upgrade ? if the encoding of the page is Unicode(UTF-8) the look like this "f�brica".
Is there a way to convert the whole database to one particular format ? in this case Unicode(UTF-8) ? And thanks for your time, I don't know how that happened, I don't mess around with that DB, I have no idea how it works.

This person had the same issue with a Wordpress DB:
http://climbtothestars.org/archives/200 ... -to-utf-8/

All I need to convert is withing "Links" the Title and the Description.

It was probably "latin1_swedish_ci" the default for MySQL, which is fine for English but not languages with special characters.

Thank you very much, whatever you did is working, I no longer have to change the punctuation and I can read it fine using Unicode UTF-8 or ISO-8859. About the old symbols nothing can be done. Thanks again.