Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Michael Monaghan (mickmongmail.com)
Date: Sun Jul 29 2007 - 09:23:18 CDT
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.
# 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
> Thanks for any help!!!!!!!
> 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