Home » Subjects

Subjects: Technology 技術

PCs suck...

Posted 2006-07-27 (木) 午前12:47 by terra

I hate PCs. They mess up when you need it most (like when you’re tired but need to send out something and then go to bed) and by the time you’ve fixed them you’ve been robbed of 2 hours meant for relaxation…grrrrrrrrrrr… >_<

Subjects: Technology 技術

Mood: Raves and Rants

Tags: PC

Remote server SQL export/import woes *Fixed*

Posted 2005-07-03 (日) 午後11:42 by terra

The following is only for my future reference and should not realy interest anyone else unless that person is facing a similar problem as I did.

Goal:

To import multilingual data from remote hosting to production server on PC, ensuring that nothing is corrupted in the process.

Problem definition:

MySQL database located on webhost (Server 1) did not import correctly multilingual text correctly. Webhost’s character set was set to latin1 whereas production server on PC (Server 2) was set to UTF-8. One is able to check the settings of the servers by typing show variables in mysql shell.

Subjects: Technology 技術

Tags: database, MySQL, unicode

Unicode Nightmare

Posted 2005-05-16 (月) 午前3:13 by terra

Migrating from MySQL4.0 to 4.1 is a complete nightmare for one whose webserver is remotely located and whose account is equipped with insufficient administrative rights. I’ve learnt quite a lot in the past two days, but suffered a great deal of grief throughout the journey.

“Was it all worth it?”, is something that I’ve been asking myself the day I began web designing…

疲れ切った私…

Subjects: Technology 技術, Websites ウェブサイト

Mood: Raves and Rants

Tags: database, MySQL, website

PPC Win2003SE Settings for Japanese (Revised)

Posted 2004-10-02 (土) 午後9:31 by terra

日本化しよう！

Revised registry code (click here to see the outdated code)for the English OS version of PPC Win2003SE using the Japanese version of wince.nls. This has been tested with ComPOBox for Japanese input and so far works perfecty fine. Time to try a commercial Japanese input software like ATOK I guess.

Things you need…

  1. ComPOBox from here for the Kokugo Jiten.
  2. Nihon Win2003SE wince.nls from here.
  3. Any version of MSGothic (you can even take from WinXP or whatever)
  4. The registry code below…

=============Start==============

[HKEY_LOCAL_MACHINE\SYSTEM\GDI]
"FontLinkMethods"=dword:00000001

[HKEY_LOCAL_MACHINE\Software\Microsoft\FontLink\SystemLink]
"Symbol"="\\Windows\\msgothic.ttc,MS PGothic"
"Times New Roman"="\\Windows\\msgothic.ttc,MS PGothic"
"Courier New"="\\Windows\\msgothic.ttc,MS PGothic"
"Arial"="\\Windows\\msgothic.ttc,MS PGothic"
"Tahoma"="\\Windows\\msgothic.ttc,MS PGothic"

[HKEY_LOCAL_MACHINE\Software\Microsoft\FontLink\SkipTable]
"Symbol"="00a5,007e,0391-03c9,2026,2116,221a,25a0-25ff"
"Times New Roman"="00a5,007e,0391-03c9,2026,2116,221a,25a0-25ff"
"Courier New"="00a5,007e,0391-03c9,2026,2116,221a,25a0-25ff"
"Arial"="00a5,007e,0391-03c9,2026,2116,221a,25a0-25ff"
"Tahoma"="00a5,007e,0391-03c9,2026,2116,221a,25a0-25ff"

[HKEY_LOCAL_MACHINE\SYSTEM\GDI\SYSFNT]
"CS"=dword:00000080
"Nm"="MS PGothic"
"HtInPts"=dword:00000001
"Ht"=dword:00000384
"It"=dword:00000000
"Wt"=dword:00000190

[HKEY_LOCAL_MACHINE\SYSTEM\GDI\GLYPHCACHE]
"Limit"=dword:00004000

==============End===============

Subjects: Learning the Japanese Language 日本語勉強, Technology 技術

Tags: Japanese, pocket pc

PPC Win2003SE Settings for Japanese (Outdated)

Posted 2004-09-19 (日) 午後11:10 by terra

Note: The following is outdated as of 2 Oct 2004. For revised version click here.

Code for UTF-8 Japanese sites only.

Replace MS Gothic with Arial Unicode MS for fonts of other languages (UTF-8 sites) to be displayed correctly

[HKEY_LOCAL_MACHINE\SYSTEM\GDI]
"FontLinkMethods"=dword:00000001

[HKEY_LOCAL_MACHINE\Software\Microsoft\FontLink\SystemLink]
"Symbol"="\\Windows\\Fonts\msgothic.ttc,MS PGothic"
"Times New Roman"="\\Windows\\Fonts\msgothic.ttc,MS PGothic"
"Courier New"="\\Windows\\Fonts\msgothic.ttc,MS PGothic"
"Arial"="\\Windows\\Fonts\msgothic.ttc,MS PGothic"
"Tahoma"="\\Windows\\Fonts\msgothic.ttc,MS PGothic"
"System"="\\Windows\\Fonts\msgothic.ttc,MS PGothic"

[HKEY_LOCAL_MACHINE\Software\Microsoft\FontLink\SkipTable]
"Courier New"="00a5,007e,0391-03c9,2026,2116,221a,25a0-25ff"
"Arial"="00a5,007e,0391-03c9,2026,2116,221a,25a0-25ff"
"Tahoma"="00a5,007e,0391-03c9,2026,2116,221a,25a0-25ff"

[HKEY_LOCAL_MACHINE\SYSTEM\GDI\GLYPHCACHE]
"Limit"=dword:00004000

Japanese localisation on an English OS

Temporary solution (side effects not tested for) until I can find a new copy of wince.nls from Japan: replace wince.nls with Win2003’s (1st edition) wince.nls. Ensure that MS Gothic font is in the \Windows folder and not the \Windows\Fonts folder.
This is a cleaned up version of this site’s code.

Subjects: Learning the Japanese Language 日本語勉強, Technology 技術

Tags: Japanese, pocket pc