Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    Holland
    Posts
    18

    Unanswered: Question: Euro symbol appears like a '?' instead '€'

    I have SQL Server 2000 SP3 and the default Code Page is:

    I have a Table with a column of the type 'text'.
    In this column sometimes it's necessary introduce the euro symbol (€). Now, when we write this symbol, after the SQL Server show it with a '?'.

    I tried change the column collation to 'Latin1_General_CI_AI', ‘SQL_Latin1_General_CP1_CI_AI’ and ‘SQL_Latin1_General_CP850_CI_AI’ but there is the same problem.

    Does any know what the cause off this problem is?

    Thanks in advance!
    Last edited by Pedr0; 04-06-04 at 07:18.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The problem may well be a conflict between your SQL Server code page and the client machine code page. Characters that don't convert are rendered as question marks.

    The MSDN page on SQL Internationalization might help clarify things for you (then agian, it might not).

    You might try using NVARCHAR columns to see if that helps, but you may be forced to use another client (or possibly a web server) to see the Euro symbols.

    -PatP

  3. #3
    Join Date
    Apr 2004
    Location
    Holland
    Posts
    18
    THX, I will look into it!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •