Re: To see Asian Characters in mysql

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].

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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=mickmon@gmail.com
>
>

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com