Hi all

I'm looking for a way to create a bilingual website from scratch, what I'm aiming to do is an english and arabic website but my problem is that the database doesnt save arabic data, intead after i enter the data i get (?????) in it's place.

so i'm looking for two things, i code or tutorial that will help me:

1) translate the english webpages into arabic

2) allow the database to read arabic data as well as allow me to use it in grideviews and detailview

on a final note: This is a graduation project and we are required to use VB.NET language, as far as my seach go i've only found C#  so your help will be much appreciated

 Hello,

What databsae type you are using?

If mssql, then set the fields types to

nvarchar instead of varchar

 nchar instead of char

ntext instead of text

Does that make sense? 

Hi thanks for ur effort

our college requirements are to use mdf databases ... does the way you told me apply to this as well?

Yes, this is MSSQL database.

If you need further help let me know.

Regards 

thanks is there a way for me to do it on a mdf  database?

 also i want some way i can translate my info to arabic automatically in the page

mdf = MSSQL :)

For the translation, there is no direct way for that unless you find a webservice or an API for that from a third party vendor like google. I would advice you to save your data in 2 languages.

Regards 

oh really? lol didnt know that

okay what if i wanted to input arabic data into the database from a forum or when i want to edit the data from gridviews, i tried it and it gives me (????) in the database then

sorry about all the Qs and i'm really desperate

What are the data fields types you are having the table?

well most of them are varchar

As i said in the first reply, you have to use the unicode datatypes

Convert varchar to nvarchar .... and the other fields

Regards 

thanks i'll try that