Hi together,

long time ago - but i am still here with a new question.

Installed and using WWF in version 9.05 with member API. No probs so far. But know we  also have chinese and other foreign languages on board.

1.)  In the member API the authentification is going through the existing Sessions we have (USERNAME and PASSWORD). When the user is coming the first time to the forum - a new author will be created. The username session variable we show up at the page (header.asp) already on an other position - thats ok. But by creating a new user in tblAuthor the username will be stored like this:

和平Name = ??Name

So - the value of the session is utf-8 - but this will not going into the tblAuthor auf wwf.
Any Help around?

2.) Topics are stored as UTF-8 but the message content not. Is "text" also utf-8 like nvarchat(xyz) for MS-SQL Server? (we use 2005)


(I went through the release notes to check if there where some utf-8 related updates. Did not found them).

OK - would be nice if somebody can have a look on it.
Sebastian

UPDATE/Add. information:
Yes,  in setup_options_in.asp i have  Const strPageEncoding = "utf-8"




Edited by efscl - 02 September 2008 at 9:29am

Try changing the LCID locale for the ASP pages. See the following page for more info:-

http://www.webwiz.net/kb/asp_knowledgebase/date_time_settings.asp

The reason text is used and not nText is for backward compatibility with previous versions. When the SQL Server version was introduced most web hosts used SQL Server version 7 which didn't support nText or nvarchar. If it were to be changed now it would break all those upgrading from previous releases. Not using nText and nvarchar shouldn't make any difference though and would not stop the forum from running.

Sorry I don't have any other suggests for this type of multiple language/character set setup.

Hi Bruce,

found the reason - but do not know the solution:

in functions/functions_member_API.asp we added at line 393 (after executing the sql-insert statement for a new user) an response.write strSQL and a response.end()

Result:

1. the page is showing up as an UTF-8 page
2. The SQL Statement is correct like ".... 和平Techi ..." (value of the strUsername)
3. but in the database the value of the username results in an "??Techi"
   

Any idea? Im testing further....