nvarchar notation accepted? - Mailing list pgsql-hackers

From Jaime Casanova
Subject nvarchar notation accepted?
Date
Msg-id AANLkTilm8PWD3RAiRiAn548h1Zv7Lb-HcB7n-Sbw0eJS@mail.gmail.com
Whole thread Raw
Responses Re: nvarchar notation accepted?
List pgsql-hackers
Hi,

i migrate a ms sql server database to postgres and was trying some
queries from the application to find if everything works right...
when i was looking to those queries i found some that has a notation
for nvarchar (ej: campo = N'sometext')
i was expecting those to fail but this actually works, is that fine? i
know, we can use E'' strings but N'' ones are no where documented, so
can i rely on those or i have to change those strings?

"""
create table t1_nvarchar(col1 text);
insert into t1_nvarchar values (N'texto');
"""

--
Jaime Casanova         www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: List traffic
Next
From: Robert Haas
Date:
Subject: Re: quoting and recovery.conf