How to display UTF-8 characters properly

Moderator: NorbertKrupa

Post Reply
User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

How to display UTF-8 characters properly

Post by Julie » Wed Sep 19, 2012 1:09 pm

Hi,

Anyone know how to display UTF-8 characters properly in VSQL?

Example:

Code: Select all

dbadmin=> select chr(65500);
 chr
-----
 ï¿
(1 row)
It should display a Halfwidth Hangul Letter I - (See http://unicode-search.net/unicode-names ... erm=HANGUL)

Note: I have a user with some crazy data that needs cleaned up and we're finding these weird special characters.
Thanks,
Juliette

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: How to display UTF-8 characters properly

Post by id10t » Wed Sep 19, 2012 2:16 pm

Hi!

VSQL works properly with UTF-8, you just need appropriate fonts that support UTF-8; like: DejaVu mono, FreeFont mono, Consolas. I don't sure, but "courier" from MS support UTF-8 too (!!!NOT "courier new" or "courier pinch 10"). I very like "Consolas" - most beatiful font (as monospace font).

Code: Select all

db=> select 'hello' as English, 'שלום' as Hebrew, 'привет' as Russian;
 English | Hebrew | Russian 
---------+--------+---------
 hello   | שלום   | привет
(1 row)
Example of DejaVu + chines (???):
Image

PS:
1. http://en.wikipedia.org/wiki/Hangul
2. http://www.hangulfont.com/
3. http://www.tumblr.com/tagged/hangul-font
4. http://www.omniglot.com/writing/korean.htm

Post Reply

Return to “vSQL”