Print Page | Close Window

problem with SQL 2000 when use it . . .

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10484
Printed Date: 08 April 2026 at 11:56am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: problem with SQL 2000 when use it . . .
Posted By: FARSHAD
Subject: problem with SQL 2000 when use it . . .
Date Posted: 17 May 2004 at 1:06pm

Hi

 

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

Login , this happened when this forum use SQL 2000 DB and I found that

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




Replies:
Posted By: FARSHAD
Date Posted: 18 May 2004 at 12:01am

Hi

anybody help me i need it

 



Posted By: dpyers
Date 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.



-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: thekiwi
Date 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. 


-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net