Codepage mismatch I think

johndotfoxley_at_laywheelerdotcom
Date: 05/07/04 

Date: Fri, 7 May 2004 04:31:34 -0700

I am running SQL server 7 on an NT 4 server here in the UK
which has a table containing French and Italian wine
names. Most of the characters with accents are recognised
fine but not the letter c with an acute (/) accent on it
(the database records are populated by typing it out in
Word and pasting it into the database table). If I use
Query Analyser to then search for this character it does
not find it unless I precede the search string with the
letter N, as in like N'%c%' (where the c has an acute
accent). Then it finds all occurences of this in the
table. This has other implications with our report writer
(compiles sql code) as the report fails when encountering
a record with this character. I think it is a codepage mis-
match somewhere but don't know what I need to do to fix it.

Relevant Pages

  • Re: Codepage mismatch I think
    ... such characters from your database as a workaround for the problem with ... specify that character without the N prefix, ... It sounds to me like your report writer has a bug, ... >fine but not the letter c with an acute accent on it ...
    (microsoft.public.sqlserver.mseq)
  • Re: This week on Dancing with the Stars Re: The Business Memoir - the ``whom question
    ... This was about an actor speaking with the express purpose of having ... An actor attempting to imitate an accent is absolutely, ... One character speaks with a Manchester ... Hugh Laurie's General American is impeccable in *House*, ...
    (sci.lang)
  • Re: Too few Asian Voice Actors
    ... one important issue is the right accent for the ... character is dubbed with a generic, ... The voice was changed by the time the film was released in the U.S. ... I have a kung fu movie where all the English dub voices are Asian VAs ...
    (rec.arts.anime.misc)
  • Re: Too few Asian Voice Actors
    ... > Relic watched a cat walk across the keyboard, randomly typing the ... and had the accent to prove it). ... > removed before the movie was filmed. ... He played a character called "Briar Gates", ...
    (rec.arts.anime.misc)
  • Re: Angband with an accent: displaying extended characters
    ... > In the text file pharser, we need something to look at a name. ... which means forward slant accent. ... The third character is the letter ... Why not use a function hook to translate such things, ...
    (rec.games.roguelike.angband)