I need to still update the user documentation on the creation of databases. For mysql, your create database statement needs to be something like:
CREATE DATABASE codestrikerdb CHARACTER SET utf8 All the text fields in the database should be stored as utf8 text, not gb2312, otherwise we will run into problems. I'd suggest deleting your database, and creating it again with the above setting, and try again. I will be away for a week from tomorrow, but back again next Wednesday. Cheers, David Hertz Wang 王怀志 wrote: > Hi David, > > Thank you for your so quick improvement! I downloaded and tried it again, it > works fine when I upload topic text, all the Chinese characters are rendered > correctly, but it doesn't work when I compare 2 different cvs version, all > the Chinese characters are still not right. > > Here is my configuration, > Apache 2.0 > ActivePerl 5.8.8.817 > MySQL 5.0.12 > Version control system - CVS > CodeStriker 1.9.2 alpha7(change the $topic_text_encoding to gb2312, change > email.pm to support email authorization) > > I went through the database and found the content in the document field in > the topic table is not correct(for displaying Chinese character), I am not > sure it is mysql bug or my setting error. I set the charset for each text > field to gb2312, I'll change to some other charset see what happened. > > it still doesn't work when email comments(stop receiving response, same as > before). > > Best regards, > > Hertz > > -----Original Message----- > From: David Sitsky [mailto:[EMAIL PROTECTED] > Sent: 2006年5月30日 15:24 > To: Hertz Wang 王怀志 > Cc: codestriker-user@lists.sourceforge.net > Subject: Re: [Codestriker-user] Issues in the 1.9.2 unicode version > > Hi Hertz, > > Try downloading codestriker-1.9.2-alpha-7 now. There is a new configuration > variable $topic_text_encoding (which defaults to utf8 if it is not set), > which in your case, you should set to 'gb2312'. Once I did that, the source > files you sent me were rendered correctly, and the emailed comments were > also rendered right. > > Please download it and let me know how you go. > > Cheers, > David > > Hertz Wang 王怀志 wrote: >> Hi David, >> >> In China, we use GB2312 to encode text(simplified Chinese), for >> Traditional Chinese, I think it's BIG5, I'll check it again and tell you > later. >> Hertz >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> David Sitsky >> Sent: 2006年5月30日 7:23 >> To: Hertz Wang 王怀志 >> Cc: codestriker-user@lists.sourceforge.net >> Subject: Re: [Codestriker-user] Issues in the 1.9.2 unicode version >> >> Hi Hertz, >> >> Thanks for your email. Yes, one of the last issues to handle is the >> actual topic text itself, when it is not ISO-8859-1. I am working on >> these issues now, this also explains why adding the comment is not >> working, as the email contains non ISO-8859-1 text when displaying the > source code lines. >> I'm working on these issues next. >> >> Just out of interest, what character encoding are your source code files > in? >> Cheers, >> David >> >> Hertz Wang 王怀志 wrote: >>> Hi David, >>> >>> >>> >>> I tried Unicode version and found it's great ^_^, I can now input >>> Chinese characters in the topics and comments, it's very convenient >>> for us. And I also found the following issues in the Unicode version, >>> >>> >>> >>> 1. the comments in the code doesn't support Chinese, they are >>> replaced by question marks. “?” >>> >>> >>> >>> 2. email notification doesn't work when adding a comment, but it >>> works fine when creating a topic. >>> >>> >>> >>> It always stops here. When I run it in the server, it prompt the >>> object is null, the code is in the line 412 in >>> codestrikerhtml\codestriker.cs file, the response is null. >>> >>> >>> >>> Thank you and best regards, >>> >>> >>> >>> Hertz >>> >>> >>> >>> >>> >> >> >> >> > > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > Codestriker-user mailing list > Codestriker-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/codestriker-user
_______________________________________________ Codestriker-user mailing list Codestriker-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/codestriker-user
