BorlandTalk.com

surena · Guest

To connect to a table in SQL server 2000, I put datasource, adotable,
dbnavigator and dbgrid in a form. I wrote a code like:

datamodule2.ADOConnection1.Connected:=true;
adotable1.Connection:=datamodule2.ADOConnection1;
adotable1.TableName:='patient';
adotable1.Open;
datasource1.DataSet:=adotable1;
dbgrid1.DataSource:=datasource1;
dbnavigator1.DataSource:=datasource1;

After running I have access to the 'patient' table. I use unicode
(persian alphabet) in one field of my original table, but now I
see ??? characters in their place. Also when I insert persian alphabet
in the delphi table, I see some strange characters in the original SQL
table. How I can configure my project such that I retrieve persian
alphabet from SQL table and also insert them from the project into SQL
table? In my original SQL table I use'nvarchar' data type for this
alphabet.

Surena