Skip to main content
A
Anonymous
March 10, 2010
Question

SQL EXPRESS not supporting french accent

  • March 10, 2010
  • 2 replies
  • 1360 views

I imported a database into my server. When I read a record with Coldfusion 8, the accents are displayed but when a save the record the accents are replaced with a "?" (question mark). I'm not an experienced developer. If anybody can give me a clue!

Thanks

Jean

This topic has been closed for replies.

2 replies

T
TLC-IT
Inspiring
March 16, 2010

Isn't that what the nvarchar column-type is supposed to address?  I haven't used it . . .

A
Adam Cameron.
Inspiring
March 11, 2010

Where is the data coming from that you're writing back?  Is it simply querying the DB for some data, and then immediately writing it back, or are you

displaying the values in a form, posting the form, and writing the posted data back to the DB?

Does the data get corrupted when the form is posted, as opposed to when the data is written back to the DB, IE: do you know it's getting corrupted between CF and the DB?

Are you setting the encoding for the form post?

You need to make sure all the contributing pieces know which encoding to treat the data as.

--

Adam

A
Anonymous
March 11, 2010

The problem appeared when I changed my hosting provider. I moved from Coldfusion MX and SQL 2000 to Coldfusion 8 and SQL Express. I do "input" into a form and a query update. I tried with charset UTF-8 and iso-8859-1 but I got the same result.

The first screen below is what I get in reading the record and the second screen after the update.

My undestanding is that the data is effectively corrupted when the form is posted back to the DB. Why? That's my problem.

Tanx

Jean

T
tooMuchTrouble
Inspiring
March 11, 2010

is the table defined the same way, ie with "N" datatypes? is the driver the db

same, ie the JDBC one (can't be ODBC)?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices