[How To] Translating DB

[dungeonmaster]

Alright guys i have been holding onto this trick for a while, recently i have been getting emails from people on how to translate the Unicode into English. I will not release my program yet due to its not stable and not ready for release. It was made to translate Unicode UCS2/UTF16 into basic chinese, then translated basic Chinese into English. My program translated it into English and automatically added ~ for the spaces.

But i will tell you how to do it a simple way takes a few seconds longer than my program but i will show you how you can do it in a few seconds.

Materials Needed:
*Translator (Bing or google)
*NJStar Communicator

Download NJStar from here

Once you have downloaded NJStar run it

You will notice a little box in the upper right corner of your screen
*Click the chinese letter in red
*Scroll down to universal code convertor

It will bring up a new applicaition

Now go into navicat and copy a line you wish to translate(Please note only do one action line at a time)

Once you have copied the line you want, it will automatically put it in the application, it should auto detect the Unicode but if not, look in the left hand box on the bottom select Unicode UCS2/UTF16

Once you have done that go to the right hand box and select Chinese GB

Now hit Convert to clipboard, now copy the new line of code from the box above and paste it into Google or bing it will auto detect but if not choose translate from Chinese to English.

Now your Unicode is in English

Dont forget to replace the spaces with ~ or it will not read in the DB

I might work on releasing my program in the future if i get enough people wanting it

Dont forget to hit thanks if this is helpfull

[bladeofthedark]

*hits the thanks button*

[dungeonmaster]

hopefully that will cut the spam emails.

[bladeofthedark]

Originally Posted by dungeonmaster

hopefully that will cut the spam emails.

spam is nasty dude, i use ham....

[dungeonmaster]

ham is good spam is not

[bladeofthedark]

Originally Posted by dungeonmaster

ham is good spam is not

sweat roasted honey ham

[Kyra_Wyndmere]

Originally Posted by bladeofthedark

sweat roasted honey ham

Sadly I can't eat ham I'm allergic So I'll take your word for it.

[bladeofthedark]

Originally Posted by Kyra_Wyndmere

Sadly I can't eat ham I'm allergic So I'll take your word for it.

wow dude ham is like my fav... i feel for you >.<

[-The-Shadow-]

That program isn't awful for translation purposes, however if someone is serious about doing them, they should write up an app that has 2 textbox areas that takes input of codepage 936 (cn) and outputs codepage 1252 (en).

Also adding a 3rd textbox input that takes hex would allow for raw file translation. The tool I wrote for Omni did this and it made translation copy/paste fairly easy.

I say this because the Chinese in Zero isn't actually a Unicode type but codepage 936 oldschool. In fact for the database part you are reading the codepage 936 data as English character data and need to convert it to down to raw bytes then view it on a codepage 936 set display to see real Chinese characters to get a proper translation as you may get gibberish Chinese using the wrong encode type.

So the proper process on the majority of the Database stuff is ascii ->- bytearray ->- codepage 936 display ->- translate (and extra step of translate ->- hex for raw file translate).

This is how it works for all the T(errible)Q(uality) games. That is all for this days nerd lesson 101.

[dungeonmaster]

Originally Posted by -The-Shadow-

That program isn't awful for translation purposes, however if someone is serious about doing them, they should write up an app that has 2 textbox areas that takes input of codepage 936 (cn) and outputs codepage 1252 (en).

Also adding a 3rd textbox input that takes hex would allow for raw file translation. The tool I wrote for Omni did this and it made translation copy/paste fairly easy.

I say this because the Chinese in Zero isn't actually a Unicode type but codepage 936 oldschool. In fact for the database part you are reading the codepage 936 data as English character data and need to convert it to down to raw bytes then view it on a codepage 936 set display to see real Chinese characters to get a proper translation as you may get gibberish Chinese using the wrong encode type.

So the proper process on the majority of the Database stuff is ascii ->- bytearray ->- codepage 936 display ->- translate (and extra step of translate ->- hex for raw file translate).

This is how it works for all the T(errible)Q(uality) games. That is all for this days nerd lesson 101.

I know making an app is easier but im not releasing mine yet, mine has 3 text box first is the input which is the unicode, the second box is translated to english then if you click the to mysql button i have it adds ~ to spaces so its just a copy paste deal

[Alex06052]

I already have this do hickey, thanks to Shadow , hes a great mentor... lol

[dungeonmaster]

well i have my own program but im not releasing it. this way is common on any server, but i was just getting tired of the emails.

[bladeofthedark]

Originally Posted by dungeonmaster

well i have my own program but im not releasing it. this way is common on any server, but i was just getting tired of the emails.

and this is why i love block buttons XD

[dungeonmaster]

they find ways to find me ive changed emails several times

[MizTenshi]

hmm is it the one funhacker released? there are a few released on eo section.