Re: Multi language site and character encoding

[Eric Worthy]

So, Bijan, I have a standard MySQL database using Innodb tables. (5.0.13)

I also have a front end written in PHP.

So far, in looking at your post above, I have created the following database:
mysql> create database test_lang character set utf8 collate utf8_general_ci;

From there, I can create tables,etc...

Now, if I wanted to query, say, Spanish out of the database, how do I do that?

I come from the Oracle world and I can set my language variable in my session
to show Spanish. Is it similar in MySQL?

Thanks for your help. I'm digging through the MySQL docs and it's just not making sense.



Edited 1 time(s). Last edit at 11/02/2005 12:06PM by Eric Worthy.