1. Japanese Text to MySQL DB with Win32Lib
- Posted by Dave Probert <zingo at purpletiger.com>
Sep 17, 2005
-
Last edited Sep 18, 2005
Hi Guys,
I'm trying to deal with some multilanguage stuff for a small project I'm messing
with.
Basically I have a (Win32Lib) window with a RichEdit control in it. A person
can type in Japanese here and I'd like to be able to get what they type either as
UTF8 data or converted to UTF8, to drop into a MySQL4.1 (UTF8 supported)
database. The problem is I have no idea how to get the data back in a suitable
format. Has anyone done anything like this?
I'd also like to be able to pull the UTF8 data from the DB and redisplay it in
the RichEdit control as well.
I've taken a look at the Multilingual stuff in the archives - but that's all
about displaying the Japanese - not reading it back (as far as I can see
anyway!), but it does have some stuff for the RichEdit redisplay, but not from
UTF8 - only Unicode.
Any help or guidance here would be appreciated.
Cheers,
Dave
. .. : :: = == == = :: : .. .
Server-Side DB driven web sites,
Software Development
(and part-time games developer)
contact dave_p at purpletiger dot com
or probert.dave at gmail dot com
. .. : :: = == == = :: : .. .
2. Re: Japanese Text to MySQL DB with Win32Lib
Dave Probert wrote:
>I'm trying to deal with some multilanguage stuff for a small project I'm
>messing with.
>
>Basically I have a (Win32Lib) window with a RichEdit control in it. A person
>can type in Japanese here and I'd like to be able to get what they type either as
>UTF8 data or converted to UTF8, to drop into a MySQL4.1 (UTF8 supported)
>database. The problem is I have no idea how to get the data back in a suitable
>format. Has anyone done anything like this?
>
>I'd also like to be able to pull the UTF8 data from the DB and redisplay it in
>the RichEdit control as well.
>
>I've taken a look at the Multilingual stuff in the archives - but that's all
>about displaying the Japanese - not reading it back (as far as I can see
>anyway!), but it does have some stuff for the RichEdit redisplay, but not from
>UTF8 - only Unicode.
>
>Any help or guidance here would be appreciated.
>
>
I've done some work in this area (example at
www.welchaviation.org/J/screen.doc
<http://www.welchaviation.org/J/screen.doc>). I'll help if I can.
How is the Japanese being inputted? Which IME is being used, and what
format (EUC, Shift-Jis etc.) are the input characters in?
I use a regular text control, and do my own parsing on double bytes. A
simple check on the first character determines if it's Japanese or English.
For display, I've written routines to handle Japanese bitmap fonts,
available freely from ftp://ftp.monash.edu.au/pub/nihongo/00INDEX.html
Reason for that approach is that I'm using Win98, which doesn't really
support Unicode.
Let me know if there's any way I can help ...
--
Craig
3. Re: Japanese Text to MySQL DB with Win32Lib
Craig Welch wrote:
>
> Dave Probert wrote:
>
> >I'm trying to deal with some multilanguage stuff for a small project I'm
> >messing with.
<snip>
> >Any help or guidance here would be appreciated.
> >
> >
> I've done some work in this area (example at
> www.welchaviation.org/J/screen.doc
<snip2>
> Let me know if there's any way I can help ...
>
> --
> Craig
>
Thanks Craig,
At the moment I've paused the requirement for doing it with Euphoria by simply
having a PHP-driven page shown in a Browser (which is in a IE HTML control in the
program ;) ). The PHP handles all the input and database management parts quite
nicely. But It's not really what I wanted overall, but it works.
I'll have a good read through the links and doc to gain a better understanding
of what's required and post any further queries here.
Thanks again.
Dave
. .. : :: = == == = :: : .. .
Server-Side DB driven web sites,
Software Development
(and part-time games developer)
contact dave_p at purpletiger dot com
or probert.dave at gmail dot com
. .. : :: = == == = :: : .. .
