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