Character set and Collation

jortiz · #1 (**permalink**) 09-29-05, 17:36

Hello, I created a database 1 month ago, on mysql 4.1.16 with the default character set and collation, and I would like to know how to change It to spanish for all the table in the database.

Thanks

Chagh · #2 (**permalink**) 10-05-05, 07:51

hi,
there are some server variables that identifiy collations and character sets, you can see them by using

Code:

show variables like 'character%'

and

Code:

show variables like 'collation%'

you can change them by e.g.

Code:

 set global character_set_server = 'utf8'

but i don't know which character set you should use for spanish,
maybe this helps you:
http://dev.mysql.com/doc/mysql/en/charset-we-sets.html

Chagh

Internet Services

Web Development

Digital Marketing

Consumer Tech