FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


ALTER TABLE mySQL problem.





Arin
Hi,

I am trying to set a default charset for a table in database, and I cant do it :/. I'm with command in phpMyAdmin:
Code:
ALTER TABLE `translations` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

and I am getting an error:
Code:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1

Well.. manual... http://dev.mysql.com/doc/refman/5.0/en/charset-table.html

Any ideas what to do??


Cheers,
Arin,
Daniel15
The character sets feature was introduced in MySQL 4.1, so the feature is only available on hosts that use MySQL 4.1 or 5.0. FriHost (like most other web hosts) runs MySQL 4.0, so you can't use that feature here.
Arin
daniel15 wrote:
The character sets feature was introduced in MySQL 4.1, so the feature is only available on hosts that use MySQL 4.1 or 5.0. FriHost (like most other web hosts) runs MySQL 4.0, so you can't use that feature here.


Ok, this is something.

Arent there any other ways to set up how values in table will be stored? It doesnt need to be in ut8 - I would be hapy if it would be binary.

I'm currently trying to find referrence manual for v.4.0 but looks like it will be hard.

Thanks for your hint!


Cheers,
Arin.
Daniel15
If you want something to be stored as binary, use a 'BLOB' type. A 'BLOB' type is like a 'TEXT' type, except that it is stored in binary. You can see more information about BLOBs here: http://dev.mysql.com/doc/refman/4.1/en/blob.html

Quote:
I'm currently trying to find referrence manual for v.4.0 but looks like it will be hard.

You can use the MySQL 4.1 manual, the differences between 4.0 and 4.1 aren't that big... http://dev.mysql.com/doc/refman/4.1/en/index.html
Related topics
Cant access admin area after updateing to 2.0.15
mysql problem
What is useful way in this php+mysql problem?
MySQL problem...
sql with phpmyadmin
MySQL problem (as usual)
MySQL problem :'(
MySQL Problem
mysql problem
mySQL problem
mysql querries and subquerries problem..
mysql insert into multiple tables at once?
oracle sql Alter table from a triggered package procedure
MySQL problem - Can't insert stuff in to database
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.