In one of my Webmatrix pages I refer to a field "Prénom" when doing queries.
Sometimes after publishing these pages from my local to my hosted server the é disappears in the source code and SQL server does not find the column.
I have the feeling it has to do with codepage and/or Content.
Has anyone a precise idea.for a start, your columns should be of type nvarchar (or simlar n-prefixed column)
and literal strings in SQL should be n-prefixed also
UPDATE tblWhatever SET columnName = N'somé string with accénts'
this might help, if the problem is what I think it is.|||This is the case.
I have now realized that Frontpage produces pages with US/European character set, whereas Webmatrix uses UTF-8. Seems to be quite a mess making things compatible ...
Worse, when opening a Frontpage Ansi produced page with Web Matrix, this program strips out the accentuated characters, and you lose them in the process of saving.
Reverse, when you change the default in Frontpage to UTF-8, the european characters become unreadable in Web Matrix !
I do not yet know how to fix this.|||Frontpage?? Jesus H. Smith! I didn't think anyone still used that ;-)
1. what version? 2. is there anything in the options dialog which can force UTF-8 in FP?
No comments:
Post a Comment