converting data to utf-8
Posted: Sat Apr 28, 2007 9:35 am
i have loaded data originally taken from sql server 2000 to mysql
in mysql my tables are with utf-8 charset
i have an application that uses this data , when i define UTF-8 charset for my web pages i don´t see characters like Ñ correctly,i see something like ' щ ' instead of ' ñ ', when i define ISO-8859-1 for my web pages i can see ' ñ ' in a correct way but when i search into some table from my site it takes n like ñ and bring me results containing n and ñ
i tried this : pass table to a text file, convert it in linux with iconv -f iso-8859-1 -t utf8 'file.txt' but it seems to be the same
how can i change the characters in my tables in a way my utf-8 tables recognize ñ as ñ?
in mysql my tables are with utf-8 charset
i have an application that uses this data , when i define UTF-8 charset for my web pages i don´t see characters like Ñ correctly,i see something like ' щ ' instead of ' ñ ', when i define ISO-8859-1 for my web pages i can see ' ñ ' in a correct way but when i search into some table from my site it takes n like ñ and bring me results containing n and ñ
i tried this : pass table to a text file, convert it in linux with iconv -f iso-8859-1 -t utf8 'file.txt' but it seems to be the same
how can i change the characters in my tables in a way my utf-8 tables recognize ñ as ñ?