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,