Hello all.
I am working with MySQL 4.0. I have a requirement to create a data-driven
Web page to display Chinese text from a MySQL table. I'm completely new to
this, can someone tell me exactly what I need to do to make this happen?
1. For example, how do I insert the Chinese text from my source (a Word
doc) into a MySQL table without corrupting it? When I try copying and
pasting it into the mysql client command-line, the data gets trashed.
2. Once it's in, how do I get it back out into my application without
corrupting it? I'm using PHP 4.3 for the Web site.
3. If I need to make changes to the data from the command-line client, how
can I do it, especially if the query involves using a Chinese-language
string? For example, "update langdata set
menutitle='SOME_MENU_TITLE_IN_CHINESE' where
menutitle='SOME_OLD_MENU_TITLE_IN_CHINESE'"
Looked at the online manual but am sorry to say it didn't really help much.
I tried starting the server with --character-set=big5 but it didn't seem to
make much difference...
Thanks!
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw