0

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.

4
Contributors
8
Replies
9
Views
6 Years
Discussion Span
Last Post by smantscheff
0

This may help.

Thanks debasisdas, I have tried that but still did not work - am I missing the syntax or something?

0

Probably you are using the wrong character set for the connection. Try it with command line mysql and have a look at the connection variables with

show variables like "%conn%"

Set the connection character set to utf8.

0

Probably you are using the wrong character set for the connection. Try it with command line mysql and have a look at the connection variables with

show variables like "%conn%"

Set the connection character set to utf8.

Hmmm I don't think so - as I am using phpMyAdmin to run the query; I have tried this query;

SQL query:

SET NAMES 'utf8';

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

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

In phpMyadmin the Collation is SET as utf8_general_ci (multilingual) which I think is correct.

But it is still did not work. Any idea?

Edited by siabenie: n/a

0

Do not use phpMyAdmin for that. It will lead you astray. Use the command line client to debug character set issues.

0

Do not use phpMyAdmin for that. It will lead you astray. Use the command line client to debug character set issues.

How do I use a command line client? Can you please explain? As all my DB I am using phpMyadmin..

Thanks in advance.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.