Re: [Codestriker-user] Issues in the 1.9.2 unicode version

[David S. <si...@us...>]

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 =CD=F5=BB=B3=D6=BE wrote:
> Hi David,
>=20
> Thank you for your so quick improvement! I downloaded and tried it agai=
n, it
> works fine when I upload topic text, all the Chinese characters are ren=
dered
> correctly, but it doesn't work when I compare 2 different cvs version, =
all
> the Chinese characters are still not right.
>=20
> 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, cha=
nge
> email.pm to support email authorization)
>=20
> 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 te=
xt
> field to gb2312, I'll change to some other charset see what happened.
>=20
> it still doesn't work when email comments(stop receiving response, same=
 as
> before).=20
>=20
> Best regards,
>=20
> Hertz
>=20
> -----Original Message-----
> From: David Sitsky [mailto:si...@us...]=20
> Sent: 2006=C4=EA5=D4=C230=C8=D5 15:24
> To: Hertz Wang =CD=F5=BB=B3=D6=BE
> Cc: cod...@li...
> Subject: Re: [Codestriker-user] Issues in the 1.9.2 unicode version
>=20
> Hi Hertz,
>=20
> Try downloading codestriker-1.9.2-alpha-7 now.  There is a new configur=
ation
> 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 s=
ource
> files you sent me were rendered correctly, and the emailed comments wer=
e
> also rendered right.
>=20
> Please download it and let me know how you go.
>=20
> Cheers,
> David
>=20
> Hertz Wang =CD=F5=BB=B3=D6=BE wrote:
>> Hi David,
>>
>> In China, we use GB2312 to encode text(simplified Chinese), for=20
>> Traditional Chinese, I think it's BIG5, I'll check it again and tell y=
ou
> later.
>> Hertz
>>
>> -----Original Message-----
>> From: cod...@li...
>> [mailto:cod...@li...] On Behalf Of=20
>> David Sitsky
>> Sent: 2006=C4=EA5=D4=C230=C8=D5 7:23
>> To: Hertz Wang =CD=F5=BB=B3=D6=BE
>> Cc: cod...@li...
>> 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=20
>> actual topic text itself, when it is not ISO-8859-1.  I am working on=20
>> these issues now, this also explains why adding the comment is not=20
>> 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 fil=
es
> in?
>> Cheers,
>> David
>>
>> Hertz Wang =CD=F5=BB=B3=D6=BE wrote:
>>> Hi David,
>>>
>>> =20
>>>
>>> I tried Unicode version and found it's great ^_^, I can now input=20
>>> Chinese characters in the topics and comments, it's very convenient=20
>>> for us. And I also found the following issues in the Unicode version,
>>>
>>> =20
>>>
>>> 1. the comments in the code doesn't support Chinese, they are=20
>>> replaced by question marks. =A1=B0?=A1=B1
>>>
>>> =20
>>>
>>> 2. email notification doesn't work when adding a comment, but it=20
>>> works fine when creating a topic.
>>>
>>> =20
>>>
>>> It always stops here. When I run it in the server, it prompt the=20
>>> object is null, the code is in the line 412 in=20
>>> codestrikerhtml\codestriker.cs file, the response is null.
>>>
>>> =20
>>>
>>> Thank you and best regards,
>>>
>>> =20
>>>
>>> Hertz
>>>
>>> =20
>>>
>>> =20
>>>
>>
>>
>>
>>
>=20
>=20
>=20
>=20
>=20
> -----------------------------------------------------------------------=
-
>=20
> _______________________________________________
> Codestriker-user mailing list
> Cod...@li...
> https://lists.sourceforge.net/lists/listinfo/codestriker-user