Web Wiz Support and Community Forums : problem with SQL 2000 when use it . . .

Web Wiz Support and Community Forums : problem with SQL 2000 when use it . . . https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 11:58:14 +0000 Tue, 18 May 2004 15:58:39 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10484 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[problem with SQL 2000 when use it . . . : Yes ... for true internationalisation,...]]> https://forums.webwiz.net/problem-with-sql-2000-when-use-it_topic10484_post57440.html#57440 Author: thekiwi
Subject: 10484
Posted: 18 May 2004 at 3:58pm

Yes ... for true internationalisation, your text based fields should be
nvarchar and ntext, not varchar and text etc.

Your assumption looks to be spot on.
]]> Tue, 18 May 2004 15:58:39 +0000 https://forums.webwiz.net/problem-with-sql-2000-when-use-it_topic10484_post57440.html#57440 <![CDATA[problem with SQL 2000 when use it . . . : Don't know much about globalization,...]]> https://forums.webwiz.net/problem-with-sql-2000-when-use-it_topic10484_post57437.html#57437 Author: dpyers
Subject: 10484
Posted: 18 May 2004 at 2:28pm

Don't know much about globalization, but assuming you set the LCID properly for the application, did you check the language settings on the db?

someone elase can probably give you a better answer.

]]> Tue, 18 May 2004 14:28:05 +0000 https://forums.webwiz.net/problem-with-sql-2000-when-use-it_topic10484_post57437.html#57437 <![CDATA[problem with SQL 2000 when use it . . . : Hi anybody help me i need it...]]> https://forums.webwiz.net/problem-with-sql-2000-when-use-it_topic10484_post57373.html#57373 Author: FARSHAD
Subject: 10484
Posted: 18 May 2004 at 12:01am

anybody help me i need it

]]> Tue, 18 May 2004 00:01:13 +0000 https://forums.webwiz.net/problem-with-sql-2000-when-use-it_topic10484_post57373.html#57373 <![CDATA[problem with SQL 2000 when use it . . . : Hi I installed this forum and...]]> https://forums.webwiz.net/problem-with-sql-2000-when-use-it_topic10484_post57325.html#57325 Author: FARSHAD
Subject: 10484
Posted: 17 May 2004 at 1:06pm

I installed this forum and changed language files to Arabic

But I have a problem

When my users want to sign up with a Arabic name the registration completed but they can`t

The user name is correct I mean the username in the database is correct and it is Arabic

But only remain one thing that is, User Code . my problem is user code

That when the users enter Arabic characters , the User Code in the DB can`t show

It correctly

I found that this line in SQL Setup File :

[User_code] [nvarchar] (50) NOT NULL

This is the code to create User Code column in the DB

But I don`t know what I must to do with this code

Until the user codes with Arabic characters, don`t convert to English and Unreadable characters

I had same problem with the messages that the users sent

When they typed Arabic characters after Sending, in the forum posts page

We see just these :

??? ???? ????? ??? ? ?????? ????? ? ?

Yes Question mark

But I solved this problem by this :

This is the code that make Message column in the DB in the SQL Setup files

[Message] [ntext] NULL ,

Yes I changed the [text] to [ntext]

And know it work fine

And know my problem is this :

My users can`t sign up with Arabic User names

Please Help me I need it

Thank you for your reply

]]> Mon, 17 May 2004 13:06:08 +0000 https://forums.webwiz.net/problem-with-sql-2000-when-use-it_topic10484_post57325.html#57325