Monday, December 13, 2010

Tamil charset in Postgresql

Storing Tamil charset into postgresql database.
I'm assumed your Operating System were installed Tamil font.

1) Create database in Postgresql with Encoding style as UNICODE

CREATE DATABASE tamildb
WITH OWNER = postgres
ENCODING = 'UNICODE';

2) Create table to insert Tamil charset

CREATE TABLE tamitbl (
emp_no int, emp_name varchar(50) );

INSERT INTO tamiltbl VALUES91,'சோலை முருகன்')

since your Operating System were installed Tamil fonts, table would accept records in tamil charset.

likewise you can add any other language charset valuse provided
OS were installed fonts.

No comments: