Howto ?

x28act

I have a database with 2 tables that contain spanishsh characters.

I need to replaces its with english characters. i.e: á with a, etc

I try with :

$from="á";
$to="a";
$Link = mysql_connect ($localhost, $user, $password) or die(mysql_error());
mysql_select_db($database_name) or die(mysql_error());

    mysql_query("UPDATE $articles SET
    field1=REPLACE(field1,'".$from."','".$to."'),
    field2=REPLACE(field2,'".$from."','".$to."')
    ");

but it don't make any changes because (I suppose) don't searchs all the characters

\anybody can help me?

Thanks in advance

crimaniak

codepage of MySQL table must be the same as codepage of your PHP script. It's the first point to check. Then try to search :
SELECT * FROM tablename WHERE field1 like "%your_special_symbol%"

x28act

i'm newbie

where to set its in linux?

x28act

the fact is this

I have a database made with geeklog portal and I want to migrate to tiki wiki

I made an script to do that which works fine but when with phpMyAdmin i watch the tables, spanish character are inside (á,etc) but when I edit with tikiwiki the articles its changes and its are converted in Ã¡, etc

I think if i convert á in a and so, I'll solve the problem

Is it correct?

crimaniak

where to set its in linux?

http://dev.mysql.com/doc/mysql/en/Charset.html

I made an script to do that which works fine but when with phpMyAdmin i watch the tables, spanish character are inside (á,etc) but when I edit with tikiwiki the articles its changes and its are converted in Ã¡, etc

I think if i convert á in a and so, I'll solve the problem

Is it correct?

Yes, but this is a bad way. Search for software able to work with non-English characters or try to use tikiwiki in UTF-8 mode. I don't know it and can't help with this package.