Post reply

convert to unicode

  • March 24, 2011 at 9:10 am

    #234530

    Hi all,

    Is there a way to find out if the database is unicode? We currently use Latin1_General_bin collation for some fields in the database. I'm not sure if this means its unicode. Also is there a way to change the database to support unicode? Is it tedious work?

    We are planning for a project that involves multiples databases, so any info that you could shed will be helpful.

    Thanks

  • March 24, 2011 at 10:55 am

    #1303108

    a column that can handle unicode will have a n prefix on the datatype

    e.g. nvarchar, nchar

    collation refers to the sorting and matching of character data.

  • March 28, 2011 at 2:36 pm

    #1304580

    Thanks

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

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