Last post May 10, 2008 11:57 PM by antica
May 04, 2008 03:57 AM|antica|LINK
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
May 04, 2008 05:35 AM|smiling4ever|LINK
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?
May 04, 2008 06:39 AM|antica|LINK
Hi thanks for ur effort
our college requirements are to use mdf databases ... does the way you told me apply to this as well?
May 04, 2008 08:55 AM|smiling4ever|LINK
Yes, this is MSSQL database.
If you need further help let me know.
May 07, 2008 12:27 AM|antica|LINK
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
May 07, 2008 10:57 PM|smiling4ever|LINK
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.
May 07, 2008 11:32 PM|antica|LINK
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
May 07, 2008 11:34 PM|smiling4ever|LINK
What are the data fields types you are having the table?
May 08, 2008 03:01 AM|antica|LINK
well most of them are varchar
May 08, 2008 04:14 AM|smiling4ever|LINK
As i said in the first reply, you have to use the unicode datatypes
Convert varchar to nvarchar .... and the other fields
May 10, 2008 11:57 PM|antica|LINK
thanks i'll try that [:D]