| Author |
 Topic  |
|
dirkpauw
Starting Member
Belgium
4 Posts |
 Posted - 14 September 2006 : 03:37:20
|
Looks like nobody runs unicaode versions in SQLserver?
THe Forum code lacks the N'' prefix for inserts and updates.
Without, all special chars are lost ...
Didn't find other refs to the problem, strange ... |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 14 September 2006 : 03:55:40
|
| it has never cropped up before because the forum is primarily designed to support english and therefore does not require unicode strings |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 September 2006 : 04:44:41
|
| What are you talking about? There are several nvarchar and ntext fields, for the fields that matter (T_SUBJECT and T_MESSAGE, for example). The forum will support unicode right out of the box. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 14 September 2006 : 08:24:36
|
to insert unicode into a sqlserver db you have to prefix the string with N ie
INSERT INTO FORUM_REPLY (R_MESSAGE) values (N'some unicode characters here') and that is not done by the forum |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 September 2006 : 08:44:51
|
Huw,
If you set the LCID and / or the session codepage and charset, unicode can be inserted by the user and it will be inserted in the DB without any issues whatsoever.
Our forum has been used in different languages, highly dependent on unicode storage, like chinese, japanese, turkish, and many more (portuguese as well). |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 14 September 2006 : 08:55:43
|
| yes I agree rui, but without using the N'string' notation you are limited to a specific characterset at a time, the correct way to insert literal strings into a database is by using the unicode notation. and besides, I'm not sure why dirkpauw asked the question, since being belgian should require unicode as European languages are supported by the standard character set |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 14 September 2006 : 09:06:16
|
| Well Huw, you can always use codepage 65001 and utf-8 as the charset, and you can support every single char you need. I do understand the issue though, even if, as you correctly put it, I haven't seen this as being a problem at all, in all my years at Snitz. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 14 September 2006 : 09:15:56
|
quote:
use codepage 65001 and utf-8
yes that is true.
quote:
I haven't seen this as being a problem at all, in all my years at Snitz
nope neither have I |
|
|
|
twin
New Member
78 Posts |
Posted - 13 March 2007 : 05:17:47
|
We have updated our SQL-Server from 7.0 to 2004 and now we have problems with these characters (i.e. german ö ä ü).
When i look in the database directly the characters are correct, so what can be the problem ?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 13 March 2007 : 05:24:28
|
| I really don't know much SQL Server 7.0. Maybe your SQL Server is running in an OS not in the german language... I don't think chaging the LCID to a german LCID will help, but you can try it. Other than that, following the advice in this thread should do it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
twin
New Member
78 Posts |
Posted - 13 March 2007 : 05:39:29
|
SQLserver is running in german also.
Itried to change the LCID.SESSION from 1033 to 1031 but that didn't work.
So, where can i change the charset and session codepage ? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
twin
New Member
78 Posts |
Posted - 13 March 2007 : 06:17:04
|
i can set Response.CharSet = "utf-8" but
Response.CodePage = 65001 does not work. Codepage is not defined ?
|
|
|
|
twin
New Member
78 Posts |
Posted - 13 March 2007 : 06:32:08
|
and were do i have to change the HTML characterset to UTF-8 ?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
twin
New Member
78 Posts |
Posted - 13 March 2007 : 07:02:40
|
ok thank you !
I tried to save one of the asp-file into unicode format. But the IIS does not support this format and therefore maybe not the CodePage property.
I think the combination of SQLServer2005 and IIS5.0 is not the best. Probably i have to update our IIS. |
|
|
|
Topic |
|
Topic Locked
