Postgres Pro
Downloads
Home   >   mailing lists

Unicode strings and data types - Mailing list pgsql-novice

From Steve_Miller@sil.org
Subject Unicode strings and data types
Date
Msg-id OFEC658F8C.4A766260-ON86256CC4.004D7FD5@sil.org
Whole thread Raw
List pgsql-novice
Tree view 
In SQL Server, if we want Unicode data, we use data types like NCHAR and
NVARCHAR. I don't see anything like that in PostgreSQL. After some
searching, it looks like I need to create the database with Unicode
endcoding:

      createdb -E UNICODE MyDb
      CREATE DATABASE MyDb WITH ENCODING = UNICODE

Is that right? Or are there Unicode data types already in the database
somewhere, and I missed them?

Steve Miller
SIL International

pgsql-novice by date:

Previous
From: Muhammad Shariq Muzaffar
Date:
Subject: Lock timeout detection in postgres 7.3.1
Next
From: Wim
Date:
Subject: Postgres performace with large tables.