locked
Coverting of special characters as š fails (CZ) RRS feed

  • Question

  • While migrating from Oracle to SQL 2008 R2 the special characters have been transformed as ? or as square. For example: The € character has been transformed into ? and the š character to a square. Has anybody come across with such a problem during migration? Thanks.
    • Edited by Lorincz1 Friday, June 1, 2012 6:36 AM
    Friday, June 1, 2012 6:34 AM

All replies

  • what tool are you using to migrate from Oracle to SQL 2008R2 ?

    did you specify nchar instead of char as datatype for the destination column ?


    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Friday, June 1, 2012 11:27 AM
  • Hello Lorincz1

    If you are using special/extended characters is better that you use Unicode data types like nchar and nvarchar. Also you can define the collation type per column, the collation will tell the database somehow the type of language/characters you will store.

    See this link

    http://msdn.microsoft.com/en-us/library/ms144260%28v=sql.105%29.aspx

    I am not sure about that character you posted...but I would try this collation

    SQL_Czech_CP1250_CI_AS

    Thursday, June 7, 2012 10:41 PM