Re: Multi language site and character encoding
Posted by: Eric Worthy
Date: November 02, 2005 12:04PM

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.

Options: ReplyQuote

Written By
Re: Multi language site and character encoding
November 02, 2005 12:04PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.