From sgnerd@yahoo.com.sg Thu Apr  29 12:34:00 2004
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 4FB5BD1E130
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Apr 2004 09:34:00 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 44635-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Apr 2004 09:33:42 -0300 (ADT)
Received: from chn-dns.primus-india.net (chn-dns.primus-india.net
	[203.196.153.7])
	by svr1.postgresql.org (Postfix) with ESMTP id C26E1D1CAA6
	for <pgsql-sql@postgresql.org>; Thu, 29 Apr 2004 09:33:37 -0300 (ADT)
Received: from ivesia67 (ptil-138-190-chn.primus-india.net [203.196.190.138]
	(may be forged))
	by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id i3TBTGtj010666
	for <pgsql-sql@postgresql.org>; Thu, 29 Apr 2004 16:59:25 +0530
Message-ID: <011201c42dd2$69245f70$7502a8c0@hdsc.com>
From: "kumar" <sgnerd@yahoo.com.sg>
To: "pgsql" <pgsql-sql@postgresql.org>
Subject: Equivalant of SQL Server's Nchar and NVARCHAR
Date: Thu, 29 Apr 2004 06:11:43 -0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_010F_01C42DB0.D803D3C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_40_50,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200404/315
X-Sequence-Number: 17690

This is a multi-part message in MIME format.

------=_NextPart_000_010F_01C42DB0.D803D3C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear friends,
Is there any equivalent datatype of SQL Server's NCHAR and NVARCHAR, availa=
ble with Postgres 7.3.4. I want to store characters, special characters and=
 Numbers.
Please shed some light.

Thanks
Kumar
------=_NextPart_000_010F_01C42DB0.D803D3C0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Dear friends,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Is there any equivalent datatype of SQL Se=
rver's=20
NCHAR and NVARCHAR, available with Postgres 7.3.4. I want to store characte=
rs,=20
special characters and Numbers.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Please shed some light.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Kumar</FONT></DIV></BODY></HTML>

------=_NextPart_000_010F_01C42DB0.D803D3C0--




From Karsten.Hilbert@gmx.net Thu Apr  29 13:20:30 2004
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 75ED9D1E2A3
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Apr 2004 10:20:30 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 71522-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Apr 2004 10:20:13 -0300 (ADT)
Received: from mail.gmx.net (mail.gmx.de [213.165.64.20])
	by svr1.postgresql.org (Postfix) with SMTP id 828D9D1E1BD
	for <pgsql-sql@postgresql.org>; Thu, 29 Apr 2004 10:20:08 -0300 (ADT)
Received: (qmail 1758 invoked by uid 65534); 29 Apr 2004 13:20:11 -0000
Received: from p5087FE49.dip0.t-ipconnect.de (EHLO hermes.hilbert.loc)
	(80.135.254.73)
	by mail.gmx.net (mp009) with SMTP; 29 Apr 2004 15:20:11 +0200
X-Authenticated: #1433807
Received: (from ncq@localhost)
	by hermes.hilbert.loc (8.11.6/8.11.6/SuSE Linux 0.5) id i3TD50901361
	for pgsql-sql@postgresql.org; Thu, 29 Apr 2004 15:05:00 +0200
Date: Thu, 29 Apr 2004 15:05:00 +0200
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql <pgsql-sql@postgresql.org>
Subject: Re: Equivalant of SQL Server's Nchar and NVARCHAR
Message-ID: <20040429150500.C561@hermes.hilbert.loc>
References: <011201c42dd2$69245f70$7502a8c0@hdsc.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <011201c42dd2$69245f70$7502a8c0@hdsc.com>
User-Agent: Mutt/1.3.22.1i
Re-X-turn-receipt-to: Karsten.Hilbert@gmx.net
Di-X-sposition-Notification-To: Karsten.Hilbert@gmx.net
X-Confi-X-rm-Reading-To: Karsten.Hilbert@gmx.net
X-Pri-X-ority: 2 (High)
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200404/316
X-Sequence-Number: 17691

> Dear friends,
> Is there [...]

> Please shed some light.
http://www.postgresql.org/docs/7.4/static/index.html

> Thanks
You are welcome.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



From pgadmin@itsbeen.sent.com Thu Apr  29 14:19:48 2004
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 376EED1DA83
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Apr 2004 11:19:48 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 04538-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Apr 2004 11:19:30 -0300 (ADT)
Received: from out2.smtp.messagingengine.com (out2.smtp.messagingengine.com
	[66.111.4.26])
	by svr1.postgresql.org (Postfix) with ESMTP id 26C95D1CAA7
	for <pgsql-sql@postgresql.org>; Thu, 29 Apr 2004 11:19:26 -0300 (ADT)
X-Sasl-enc: Xgx1gqECZjzQ9azXXF+I7w 1083248352
Received: from itsbeen.sent.com (unknown [198.144.200.210])
	by www.fastmail.fm (Postfix) with ESMTP id 4DA65AC4BF6;
	Thu, 29 Apr 2004 10:19:11 -0400 (EDT)
Message-ID: <40910EBC.1090807@itsbeen.sent.com>
Date: Thu, 29 Apr 2004 07:18:36 -0700
From: Rob <pgadmin@itsbeen.sent.com>
User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: kumar <sgnerd@yahoo.com.sg>, pgsql-sql@postgresql.org
Subject: Re: Equivalant of SQL Server's Nchar and NVARCHAR
References: <011201c42dd2$69245f70$7502a8c0@hdsc.com>
In-Reply-To: <011201c42dd2$69245f70$7502a8c0@hdsc.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200404/317
X-Sequence-Number: 17692

kumar wrote:

> Dear friends,
> Is there any equivalent datatype of SQL Server's NCHAR and NVARCHAR, 
> available with Postgres 7.3.4. I want to store characters, special 
> characters and Numbers.
> Please shed some light.
>  
> Thanks
> 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:

http://www.postgresql.org/docs/7.4/static/datatype-character.html

Here is a short example:
create table
nvctest (
utf8fld varchar(12)
);
insert into nvctest
select convert('PostgreSQL' using ascii_to_utf_8);
select * from nvctest;

text functions including encoding conversions are here:

http://www.postgresql.org/docs/current/static/functions-string.html
  and
http://www.postgresql.org/docs/current/static/functions-string.html#CONVERSION-NAMES

Good Luck,

Rob



From josh@agliodbs.com Thu Apr  29 19:20:03 2004
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 602C0D1E93C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Apr 2004 16:20:03 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 27176-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Apr 2004 16:19:44 -0300 (ADT)
Received: from davinci.ethosmedia.com (server228.ethosmedia.com
	[209.128.84.228])
	by svr1.postgresql.org (Postfix) with ESMTP id 6A01DD1E321
	for <pgsql-sql@postgresql.org>; Thu, 29 Apr 2004 16:19:42 -0300 (ADT)
Received: from [64.81.245.111] (HELO 192.168.1.102)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8)
	with ESMTP id 4974753; Thu, 29 Apr 2004 12:21:08 -0700
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: Rob <pgadmin@itsbeen.sent.com>, kumar <sgnerd@yahoo.com.sg>,
	pgsql-sql@postgresql.org
Subject: Re: Equivalant of SQL Server's Nchar and NVARCHAR
Date: Thu, 29 Apr 2004 12:20:01 -0700
User-Agent: KMail/1.5.4
References: <011201c42dd2$69245f70$7502a8c0@hdsc.com>
	<40910EBC.1090807@itsbeen.sent.com>
In-Reply-To: <40910EBC.1090807@itsbeen.sent.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200404291220.01457.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0
	tests=RCVD_NUMERIC_HELO
X-Spam-Level: 
X-Archive-Number: 200404/321
X-Sequence-Number: 17696

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