multibyte support

From: Ma Siva Kumar <siva(at)leatherlink(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: multibyte support
Date: 2003-11-11 08:43:21
Message-ID: 200311111413.12330.siva@leatherlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Running postgresql-7.3.2-3 which came with Red Hat 9.0.

Created a database with unicode encoding (in psql) as below:

create database leatherlink with encoding='unicode' template=leatherlinkdb;

leatherlinkdb is an existing database with the default encoding SQL_ASCII.

When I insert Chinsese strings into the database, it is taken in and displayed
back properly. But there is an issue:

In a varchar(100) field, about 15 characters fill up the whole space. Looking
at the database entry using psql show the characters in hexadecimel values.

The documentation mentions that version 7.3 and greater have mb support by
default. How to configure the database to accept and store the multibyte
characters?

--
Integrated Management Tools for leather industry
----------------------------------
http://www.leatherlink.net

Ma Siva Kumar,
BSG LeatherLink (P) Ltd,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-11-11 09:40:27 Re: Problem with create index
Previous Message Stephan Szabo 2003-11-11 08:30:18 Re: Problem with create index