Re: Equivalant of SQL Server's Nchar and NVARCHAR

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Rob <pgadmin(at)itsbeen(dot)sent(dot)com>, kumar <sgnerd(at)yahoo(dot)com(dot)sg>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Equivalant of SQL Server's Nchar and NVARCHAR
Date: 2004-04-29 19:20:01
Message-ID: 200404291220.01457.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kumar,

> I only only use ascii but...
> I believe postgresql varchar is the same as Oracle/Sybase/MS SQL
> nvarchar even though it doesn't explicitly say so here:

All of our TEXT datatypes are multibyte-capable, provided you've installed
PostgreSQL correctly. This includes:
TEXT (recommended)
VARCHAR
CHAR

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-04-29 19:34:13 Re: Multi ordered select and indexing
Previous Message Rod Taylor 2004-04-29 17:56:47 Re: Check a value in array