[Info-ingres] Nvarchar versus UTF-8 varchar

[Karl Schendel]

> On Jul 28, 2021, at 9:14 AM, Roy Hann <specially at processed.almost.meat> wrote:
> 
> A colleague has asked a question for which I have no answer.
> 
> When II_CHARSETxx is UTF8 what is the difference between VARCHAR and
> NVARCHAR?
> 
> I know NVARCHAR uses UTF-16. 

Actually, I think NVARCHAR uses UCS-2, at least on the Ingres side.  That's
not quite the same thing.

> 
> Why might I use NVARCHAR if my data can be represented with VARCHAR?

I think the answer is probably "you wouldn't".

I do try to remain as ignorant of characters as possible, though.

Karl