Post reply

A lingo Not English - UTF-16, Unicode

  • June 17, 2005 at 11:51 am

    #164979

    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

  • June 21, 2005 at 2:45 pm

    #567252

    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 2 posts - 1 through 2 (of 2 total)

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