Re: [sqlite] about Khmer unicode with sqlite

2013-09-05 Thread John McKown
It may also be the system which is actually doing the display to the
terminal. In my case, I was displaying a UTF-8 document on Linux, using
Konsole. I had set LC_ALL to en_US.UTF-8. The file had the UTF-8 sequence
0xe2 0x80 0x93, which is U+2013, or an "en dash". But I was seeing an
"latin small letter a with a circumflex". The reason was that Konsole
normally displays characters based on the old DEC VT100 character map. To
see the proper character, I had to run the Linux command:

echo -e "\e%G"

which sets Konsole from ISO8859-1 character set to UTF-8 character set.

I don't know what system, program, etc the OP is using, but it may need to
be customedto cause the display to render the proper glyphs.


On Thu, Sep 5, 2013 at 7:08 AM, Richard Hipp  wrote:

> On Thu, Sep 5, 2013 at 6:16 AM, Sarith San  wrote:
>
> > Dear Sir or Madam
> >
> > How do integrate Khmer unicode into sqlite?
> > When I try to use Khmer unicode with sqlite, the characters does not
> > display. All I see, they display in
> > English.
> >
>
> SQLite is a C-library.  It does not "display" anything.  You must be
> confusing SQLite with an interactive shell program of some kind that lets
> you interact with an SQLite database using typed-in commands.  The
> "display" is an operation of the shell program, not of SQLite itself.  If
> Khmer unicode is not being displayed correctly, then that is a fault in the
> shell program, not of SQLite.
>
> So what shell program are you using?
>
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
As of next week, passwords will be entered in Morse code.

Maranatha! <><
John McKown
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] about Khmer unicode with sqlite

2013-09-05 Thread Richard Hipp
On Thu, Sep 5, 2013 at 6:16 AM, Sarith San  wrote:

> Dear Sir or Madam
>
> How do integrate Khmer unicode into sqlite?
> When I try to use Khmer unicode with sqlite, the characters does not
> display. All I see, they display in
> English.
>

SQLite is a C-library.  It does not "display" anything.  You must be
confusing SQLite with an interactive shell program of some kind that lets
you interact with an SQLite database using typed-in commands.  The
"display" is an operation of the shell program, not of SQLite itself.  If
Khmer unicode is not being displayed correctly, then that is a fault in the
shell program, not of SQLite.

So what shell program are you using?

D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] about Khmer unicode with sqlite

2013-09-05 Thread Sarith San
Dear Sir or Madam

How do integrate Khmer unicode into sqlite?
When I try to use Khmer unicode with sqlite, the characters does not display. 
All I see, they display in
English.

Thanks,
Samuel San
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users