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, ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
