Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Exclamation Unanswered: Character set and Collation

    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

  2. #2
    Join Date
    May 2005
    Posts
    127
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •