problem with SQL 2000 when use it . . .

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

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.