Make ASP - ADODB using MS Access MDB file to display Chinese text via UTF-8

You need this:

Response.CodePage = 65001

somewhere in your asp code. Tada!

Of course you need this in the HTML header:

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

Complete list of codepage can be found here:

http://msdn.microsoft.com/en-us/library/aa752010(v=vs.85).aspx

Read More »

MySQL Problem with Japanese/UTF-8 texts

If you have tried to put Japanese or UTF-8 texts in MySQL, chances are it will show “junky” characters after you save/reopen it. An adjustment is needed to fix this simple problem:

Declare the data type as VarBinary. Problem solved.
I’ve tried changing the character set to UTF-8, using the “mysql_enable_utf8=1” setting, making SQL query like “SET CHARACTER SET utf8_unicode_ci;”, nothing seems working. Anyway the simple solution above solved the problem. I have tried it with MySQL 5.x.

Pitfall: If you are using SQLyog as your MySQL manager, you need to use version 6 of above to get it work. Anything less will not work even if you declare the data type as VarBinary.

Read More »

Paypal Login Window Set to Other Languages (Japanese) by Default

I was requested by a Japanese customer to set the default login window in Japanese. I have tried setting the lc (locale) query string to “JP”, it just works half way with English and Japanese as the choices. But Japanese was treated as second language in the locale of “JP”. The default page is still English. Then I tried all the funny things and eventually this works out right:

<input type=hidden name="locale.x" value="ja_JP">

Now the default Paypal login page is in Japanese! But of course this also needs to work with proper locale setting:

<input type=hidden name="lc" value="JP">

Read More »