Re: [sqlite] Japanese-Korean characters

2007-04-26 Thread Ulrich Schöbel
Hi Pavan,

try
http://reddog.s35.xrea.com/wiki/TkSQLite.html

It's excellent.

Ulrich


On Thursday 26 April 2007 10:26, Pavan wrote:
> Hi Ralf,
>
> Thanks for the link.  My OS is Linux.  Is there something available on
> these lines for linux ?
>
> Best Regards,
> Pavan.
>
> On 4/26/07, Ralf Junker <[EMAIL PROTECTED]> wrote:
> > Hello Pavan,
> >
> > >Can we store/retrieve Japanese/korean characters in sqlite db ?
> >
> > Yes, you can well do so, as others have already pointed out.
> >
> > If you are also looking for a Unicode GUI SQLite database manager to
> > display and edit Japanese / Korean character databases, you might want to
> > have a look at SQLiteSpy, freeware from
> > http://www.yunqa.de/delphi/sqlitespy/ .
> >
> > SQLiteSpy is designed to support any language when run on a Windows NT 4
> > and later operating system (Win2K, WinXp, Vista, etc.). I have received
> > positive reports that it works well with German, French, Eastern
> > European, Greek and Cyrillic characters. Given that your system fonts
> > supports Japanese and Koean characters, they should work just as well. If
> > you are experiencing problems, please contact me via e-mail and I will
> > see what I can do.
> >
> > Ralf
> >
> >
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> > -
> >

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Japanese-Korean characters

2007-04-26 Thread Ralf Junker
Hello Ralf Junker,

>>Thanks for the link.  My OS is Linux.  Is there something available on these
>>lines for linux ?
>
>SQLiteSpy apparently runs on Linux with the help of wine, but I have not 
>tested this myself: http://www.winehq.com/

Here is a small report on this:

  http://appdb.winehq.org/appview.php?iAppId=2672

Ralf  


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Japanese-Korean characters

2007-04-26 Thread Ralf Junker
Hello Pavan,

>Thanks for the link.  My OS is Linux.  Is there something available on these
>lines for linux ?

SQLiteSpy apparently runs on Linux with the help of wine, but I have not tested 
this myself: http://www.winehq.com/

Ralf 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Japanese-Korean characters

2007-04-26 Thread Pavan

Hi Ralf,

Thanks for the link.  My OS is Linux.  Is there something available on these
lines for linux ?

Best Regards,
Pavan.


On 4/26/07, Ralf Junker <[EMAIL PROTECTED]> wrote:


Hello Pavan,

>Can we store/retrieve Japanese/korean characters in sqlite db ?

Yes, you can well do so, as others have already pointed out.

If you are also looking for a Unicode GUI SQLite database manager to
display and edit Japanese / Korean character databases, you might want to
have a look at SQLiteSpy, freeware from
http://www.yunqa.de/delphi/sqlitespy/ .

SQLiteSpy is designed to support any language when run on a Windows NT 4
and later operating system (Win2K, WinXp, Vista, etc.). I have received
positive reports that it works well with German, French, Eastern European,
Greek and Cyrillic characters. Given that your system fonts supports
Japanese and Koean characters, they should work just as well. If you are
experiencing problems, please contact me via e-mail and I will see what I
can do.

Ralf



-
To unsubscribe, send email to [EMAIL PROTECTED]

-





--
'
Always finish stronger than you start
*


Re: [sqlite] Japanese-Korean characters

2007-04-26 Thread Ralf Junker
Hello Pavan,

>Can we store/retrieve Japanese/korean characters in sqlite db ?

Yes, you can well do so, as others have already pointed out.

If you are also looking for a Unicode GUI SQLite database manager to display 
and edit Japanese / Korean character databases, you might want to have a look 
at SQLiteSpy, freeware from http://www.yunqa.de/delphi/sqlitespy/ .

SQLiteSpy is designed to support any language when run on a Windows NT 4 and 
later operating system (Win2K, WinXp, Vista, etc.). I have received positive 
reports that it works well with German, French, Eastern European, Greek and 
Cyrillic characters. Given that your system fonts supports Japanese and Koean 
characters, they should work just as well. If you are experiencing problems, 
please contact me via e-mail and I will see what I can do.

Ralf  


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Japanese-Korean characters

2007-04-25 Thread Kenneth LO

The only restriction is to escape \0.  I've been storing GB2312, BIG5 and
UTF8 Chinese characters since 2.x versions without any problem.
Japanese/korean characters should be OK.


RE: [sqlite] Japanese-Korean characters

2007-04-25 Thread Allan, Mark
I think what he is trying to say is that you can store Japanese/Korean 
characters in your database using a UTF-8 or Unicode string. We currently use 
Sqlite and support Chinese, and plan to implement Japanese and Korean and have 
had no problems. We store the text as a UTF-8 encoded string. Provided you read 
the text out as UTF-8 encoded you should have no problems.

http://en.wikipedia.org/wiki/UTF-8


> -Original Message-
> From: Pavan [mailto:[EMAIL PROTECTED]
> Sent: 25 April 2007 13:16
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Japanese-Korean characters
> 
> 
> >UTF-8 (or Unicode) rules!
> Thanks for the quick reply. But, I havent understood.  Can 
> you be bit more
> clear ?
> 
> Best Regards,
> Pavan.
> 
> 
> On 4/25/07, Tian-Jian Barabbas [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > Pavan 提到:
> > > Hi,
> > >
> > > Can we store/retrieve Japanese/korean characters in sqlite db ?
> > >
> > > Thanks,
> > > Pavan.
> > >
> > UTF-8 (or Unicode) rules!
> >
> >Cheers,
> > Mike
> >
> >
> > 
> --
> ---
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> > 
> --
> ---
> >
> >
> 
> 
> -- 
> '
> Always finish stronger than you start
> *
> 


DISCLAIMER:
This information and any attachments contained in this email message is 
intended only for the use of the individual or entity to which it is addressed 
and may contain information that is privileged, confidential, and exempt from 
disclosure under applicable law.  If the reader of this message is not the 
intended recipient, or the employee or agent responsible for delivering the 
message to the intended recipient, you are hereby notified that any 
dissemination, distribution, forwarding, or copying of this communication is 
strictly prohibited.  If you have received this communication in error, please 
notify the sender immediately by return email, and delete the original message 
immediately.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Japanese-Korean characters

2007-04-25 Thread Pavan

UTF-8 (or Unicode) rules!

Thanks for the quick reply. But, I havent understood.  Can you be bit more
clear ?

Best Regards,
Pavan.


On 4/25/07, Tian-Jian Barabbas [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


Pavan 提到:
> Hi,
>
> Can we store/retrieve Japanese/korean characters in sqlite db ?
>
> Thanks,
> Pavan.
>
UTF-8 (or Unicode) rules!

   Cheers,
Mike


-
To unsubscribe, send email to [EMAIL PROTECTED]

-





--
'
Always finish stronger than you start
*


Re: [sqlite] Japanese-Korean characters

2007-04-25 Thread Tian-Jian \"Barabbas\" [EMAIL PROTECTED]

Pavan 提到:

Hi,

Can we store/retrieve Japanese/korean characters in sqlite db ?

Thanks,
Pavan.


UTF-8 (or Unicode) rules!

   Cheers,
Mike

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Japanese-Korean characters

2007-04-25 Thread Pavan

Hi,

Can we store/retrieve Japanese/korean characters in sqlite db ?

Thanks,
Pavan.

--
'
Always finish stronger than you start
*