Gujarati Unicode Character Display

To get and display Unicode characters in browsers is dam easy as displaying any simple string. This is my opinion after solving the Gujarati Unicode character display issue.

As you have already read my post Unicode support Java.

and you know, how I solved the issue.

Many of us working on language other than English and using Unicode as Other language support. This post may help u if you are interacting with MySql as database. I will post How to create table and database, which supports and stores Unicode characters.

I have created the sample PHP Application which displays Gujaratai Unicode. First, when I fetched the records using simple query was displaying junk data as ??????????, question marks instead original data.

Then I started to resolve the issue. What I found is When we hit the query before that we need to hit other query for setting for Collation and Character set of the system.

SET NAMES 'utf8'

and, Issue will be resolved!

So just one query...hmm great!!!

Comments

Anonymous said…
સરસ લેખ. લખતાં રહેજો..
October 15, 2008 at 10:49 PM
Post a Comment

Popular posts from this blog

Are parents really responsible for their children's bad habits?

Yesterday, when I was going home from office, I was at Rickshaw Stand waiting for Rickshaw and there were lorry peoples,suddenly I noticed one incident, where a couple with their little boy,might be 6th or 7th year old came to Rickshaw Stand. There was water lorry also, who was selling water pouch. The little boy went to the water lorry, the lorry man was busy in arranging other bags of water pouch, little boy took the water pouch and came to his parents. His Parents were seeing the pouch in the boy's hand and ask from where have you taken, he just pointed his hand to lorry. In spite of going back to lorry man and giving back the pouch or making payment, he just stood there and put the pouch into his bag. He had not even ask his son, why did he take the pouch? or taught him that, he should not do that. This is very bad, Parents are hiding their children's mistakes. These small and silly mistakes can create big troubles in life.
Read more

Unicode support Java

Few days back, I was working on one project, Project was in MySql, Java. I had to do Java, MySql Connectivity. My database was in Gujarati. (Unicode, UTF-8) To do MySql database connection using Java is very easy. string url = "jdbc:mysql://ServerIPAddress:3306/DatabaseName Where, 1. jdbc : Driver specification 2. mysql : Defining MySql database is used. 3. ServerIPAddress : This is the IP Address of the database server 4. 3306 : Port 5. DatabaseName : Name of Database So I thought this is perfect for connectivity.. Oops... but garbage value displayed when I fetched data. So what to do? I had spent 1 week to find out what is the problem? Where is the problem? Finally, I found the solution, Need to pass parameter for Unicode support. Then, I used below string as connection: string url = "jdbc:mysql://ServerIPAddress:3306/DatabaseName?useUnicode=true&characterEncoding=UTF8"; and its done. useUnicode=true&characterEncoding=UTF8 : Property...
Read more