Rename table column not working

[siabanie]

Hi all,

 

I like to rename my table's column.

My table name is: utf8_Alter

Field: Branch

 

 

In the Branch field I have few columns name

 

I tried to change the name with this query: But it didn't work.

 

ALTER TABLE `utf8_Alter` CHANGE `ゴルダーズグリーン` `ーン ノースロンドン` varchar( 64 )

MySQL said: Documentation
#1054 - Unknown column 'ゴルダーズグリーン' in 'utf8_Alter' 

 

The Collation in phphMyAdmin is :utf8_general_ci

 

Can anyone assist me what I did wrong here?

Thanks in advance.

[fenway]

There is something strange with your collations -- not sure from where you're issuing that query.

 

In general, though, it's preferable to stick to ASCII-based table names & column names.

[siabanie]

There is something strange with your collations -- not sure from where you're issuing that query.

 

In general, though, it's preferable to stick to ASCII-based table names & column names.

 

I am using phpMyAdmin to run the query and the collations said for multilingual I gotta choose UTF-8. Isn't that correct?

[fenway]

It is correct, if it's configured correctly.

[siabanie]

Yes thanks I think it's correct but when I try to run the query in PhpmyAdmin:

 

ALTER TABLE `utf8_Alter` CHANGE `ゴルダーズグリーン` `ーン ノースロンドン` varchar( 64 )

 

I got an error:

MySQL said: Documentation
#1054 - Unknown column 'ゴルダーズグリーン' in 'utf8_Alter' 

 

The UTF-8 is set okay but not sure what I missed here..any idea?

[fenway]

That means the UTF-8 isn't "set okay".