• Nvarchar versus UTF-8 varchar

    From Roy Hann@21:1/5 to All on Wed Jul 28 13:14:41 2021
    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.

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

    Roy

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)