From: Michael Monaghan (mickmongmail.com)
Date: Sun Jul 29 2007 - 09:23:18 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I can't speak to your GUI tool, but here's some general pointers:

1. You have to be absolutely sure that your system can in fact render Myanmar.
- so ensure that at least your browser can view proper Myanmar
characters - see http://www.columbia.edu/kermit/utf8.html.
This page has a sample Burmese string in UTF-8. [I'm assuming Burmese = Myanmar]

Make sure you can render this string. If you can't, you need to
download the right fonts.

> Although i changed utf 8 charset and utf8_unicode_ci collation and
> also changed Application fonts (
> Tools, Options, General Options) to our language, Myanmar, in MySQL
> query browser, i can\'t type our fonts.
> Alternatively, i input our fonts to a mysql table from a java
> application. i can input and output our fonts in application program,
> but, i can only see ??? characters in MySQL browser\'s table. How can i
> store and retrieve our fonts in mysql???

2. You need to check if your database does in fact have UTF-8 encoded
content, do the
following. Just setting the db character set to UTF-8, doesn't mean
that the db actually has UTF-8 characters.

So, try:

# mysql -e "select FIELDS from TABLE" > output.txt

- making *sure* that the output contains some of your Myanmar characters.

Then open output.txt in a browser and set the character encoding to UTF-8.

[View->Character Encoding->UTF-8 in Firefox].

If the content renders properly then you can be sure that the content in the
database is in fact UTF-8. - therefore the problem lies with the
viewer application/GUI you are using.

If the content does not render properly, - then your input data to the
db is not UTF-8 - problem lies in your Java application.

Hope this helps.

by the way - there's a very useful java internationalization forum at
http://forum.java.sun.com/forum.jspa?forumID=16

~mm

>
> Thanks for any help!!!!!!!
>
> purple.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mickmongmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]