Different unicodes for same string in java and mysql

Question

As per my knowledge i know unicode character means every letter has an unique code.

In my database i have set utl8.

Here, i am saving a string (ఉత్తరప్రదేశ్) directly into the database in java.Then it is saved as

&#3081;&#3108;&#3149;&#3108;&#3120;&#3114;
&#3149;&#3120;&#3110;&#3143;&#3126;&#3149;

But the same string i saved in database using

escapeUnicode(StringEscapeUtils.unescapeHtml("here string"));


public String escapeUnicode(String input) {
   StringBuilder b = new StringBuilder(input.length());
   Formatter f = new Formatter(b);
    for (char c : input.toCharArray()) {
      if (c < 128) {
        b.append(c);
      } else {
        f.format("\\u%04x", (int) c);
      }
     }
   return b.toString();
}

It is generating unicode as

\u0c09\u0c24\u0c4d\u0c24\u0c30\u0c2a\u0c4d\u0c30\u0c26\u0c47\u0c36\u0c4d

Both are displaying in browser correctly.Why they both are generating different unicodes ? Thanks in advance..

Basil Bourque · Accepted Answer · 2013-10-15 10:27:54Z

3

Those are not different numbers…

3081 = 0c09 = ఉ = TELUGU LETTER U
3108 = 0c24 = త = TELUGU LETTER TA
3149 = 0c4d = ్ = TELUGU SIGN VIRAMA

… and so on.

Two different ways to represent the same Unicode code point.

The first are decimal numbers (base 10). The second are hexadecimal numbers (base 16).

When using a class such as Formatter, sometimes it helps to read the documentation. Then you might understand why you pasted f.format("\\u%04x" into your code.

Tip: If you have a Mac, download the UnicodeChecker app to see both decimal and hex numbers for each character defined in Unicode.

edited Oct 15, 2013 at 10:27

answered Oct 15, 2013 at 10:16

Basil Bourque

347k130 gold badges950 silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Different unicodes for same string in java and mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related