how to get rid of special character Â?

[edward wang]

Hi Folks

When i updated a product name  using West®  East®food  in Catalog
-->Content,
in product_name field of  Product table,  the value is like this   West®
East® food.
This value is presented in PDF report file,
I want to remove  Â.
I read this article. it says I need to  set "UTF-8"  for mySQL.

SET NAMES 'utf8';

http://www.byteflex.co.uk/en/fun_with_utf8_php_and_mysql.html


but updateProdcut is using minilan in ProductServices.xml.

could you tell me how to fix this issue?
Thanks,

Chwang

[BJ Freeman]

I don't catch the link between the databae settings and the minilanq for
Â(nicode representation of high byte)

=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


chaohua wang sent the following on 6/14/2010 3:41 PM:

> Hi Folks
>
> When i updated a product name  using West®  East®food  in Catalog
> -->Content,
> in product_name field of  Product table,  the value is like this   West®
> East® food.
> This value is presented in PDF report file,
> I want to remove  Â.
> I read this article. it says I need to  set "UTF-8"  for mySQL.
>
> SET NAMES 'utf8';
>
> http://www.byteflex.co.uk/en/fun_with_utf8_php_and_mysql.html
>
>
> but updateProdcut is using minilan in ProductServices.xml.
>
> could you tell me how to fix this issue?
> Thanks,
>
> Chwang
>

[edward wang]

Thank you,
in the link, it doesn't say i can do minilang.
but it tells if i set  "SET NAMES 'utf8'" when insert a record in table, it
can fix this issue.

I just read this link, has kind of the same issue with mine:
http://forums.mysql.com/read.php?143,220627,220627

I am not sure how it happened when i input a name   West®
East® food, then updated.  It became like this in table:   West®
East® food ,which has extra char Â.

chwang

On Mon, Jun 14, 2010 at 4:55 PM, BJ Freeman <[hidden email]> wrote:

>
> I don't catch the link between the databae settings and the minilanq for
> Â(nicode representation of high byte)
>
> =========================
> BJ Freeman
> http://bjfreeman.elance.com
> Strategic Power Office with Supplier Automation  <
> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com  <http://www.specialtymarket.com/>
>
> Systems Integrator-- Glad to Assist
>
> Chat  Y! messenger: bjfr33man
> Linkedin <
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >
>
>
> chaohua wang sent the following on 6/14/2010 3:41 PM:
>
>  Hi Folks
>>
>> When i updated a product name  using West®  East®food  in Catalog
>> -->Content,
>> in product_name field of  Product table,  the value is like this   West®
>> East® food.
>> This value is presented in PDF report file,
>> I want to remove  Â.
>> I read this article. it says I need to  set "UTF-8"  for mySQL.
>>
>> SET NAMES 'utf8';
>>
>> http://www.byteflex.co.uk/en/fun_with_utf8_php_and_mysql.html
>>
>>
>> but updateProdcut is using minilan in ProductServices.xml.
>>
>> could you tell me how to fix this issue?
>> Thanks,
>>
>> Chwang
>>
>>
>