A lingo Not English - UTF-16, Unicode

  • Dear SQL Community,

    I am in the process of populating a sql table that has German data.  The table has been created using various unicode data type fields (i.e.  nchar, nvarchar). 

    What is it that I need to do next?  Can I just populate the table with english data characters and hope for the conversion to take affect upon SELECT from the table,

    OR

    Do I need a class in Unicode/Datatype Conversion?  Please help!  thanks jm

  • This was removed by the editor as SPAM

  • You may have already discovered this but you should be able to store English characters in the unicode columns.  Unicode gives you the option of storing unicode data.  If you do not, you are only wasting storage space.  Thats why most people recommend not using nchar or nvarchar unless you need to.  The unicode columns are capable of storing unaccented English characters.

    Francis

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply